Forum Discussion
Medmbchr
3 years agoHelper IV
SWITCH won't return a VAR table
Hi, I am trying to build up a virtual table using UNION and SELECTCOLUMNS, this table is variable and its content is based on another column, hence am using SWITCH so that I can build up the appr...
v-jialluo-msft
3 years agoCommunity Support
Hi Medmbchr ,
You can try using the IF function directly in RETURN. If this doesn't resolve the issue, you can provide sample data and projected output to further resolve it
Best Regards,
Gallen Luo