Forum Discussion
Unpivot + unknown columns + data type woes
Hi McSarah
So you are here in this step, and my giant list of columns is your column name list? You don't wrap it with {} as it is already a list, you can directly reference it or #"my giant list of columns" if it does have space...also seems missing closing ) and ,
#"Expanded second half of join" = Table.ExpandTableColumn(Source, "other query - second half of join", { ( my giant list of columns)}
I copied and pasted out of my real query and edited to change my real column names.. so it may be that not all the syntax is perfectly representative of what I did. However I do think I included the brackets in my query... I'll check that and report back.
It sounds like you think I should be able to pass a list in this query, so if that's the case I'll tweak it until it works.
And it was that simple. Amazing! Thank you!
Edit: I simply removed the brackets that I erroneously thought I needed. The list passed to the query as intended once I got the syntax right.