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.
Pinita06 Can you share the relevant before and after M code from Advanced Editor? Generally this happens when you added column names but not the actual columns in the expression or vice versa. You generally have to enter it twice into the expression (the name of the column).
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.