Forum Discussion
New Data source additional columns not showing
Pinita06 OK, this would have been easier with text. Expand Columns takes 4 parameters typically. There is the table, the column you want to expand in that table and then 2 lists. The first list is the name of the columns that you want to end up with and the second list is the column name that you want out of the expanded column. You need to have the same number of entries in both lists.
Solution SageI had the same issue in the past and I solved it in a different way.
In the affected Query -> Advanced Editor, in the "let" section look for the Columns descriptor. You can do one of 2 things:
1. increase the number with the new(ly) added columns. Let's say you had 10 columns and you've added 2 more then you have to change the number to 12
2. (what I did) I changed the number to null (no brackets, no nothing). This way, you don't have to do anything if you add new columns in the future.
Hope it works for you.
Hi, I looked for the #Columns and I can't find it...
This is my Historical in the Advance editor:
This is how I'm adding the columns.