如何将股票代码格式化成类似000001.SZ这种格式(后面的.SZ或.SH根据exchangecd判断)

Question

Answer 1

用format和iif，例如：

t=table(1 2 as ticker,`XSHE`XSHG as exchanged)
select format(ticker,"000000")+iif(exchanged==`XSHE,`.SZ,`.SH) from t