Forum Discussion
Solved
Expanding table in Power Query - preview shows correct value, but after expanding its incorrect
Dear comunity, I'm merging two tables to get data into first table. When I merge the two tables and click into new column to see preview of which row was mapped to the row, it shows correct value...
Your code seems rather complex. Can you strip away anything that is not relevant to the issue?
Have you considered using lookups via Table.AddColumn instead of merges?
Your code seems rather complex. Can you strip away anything that is not relevant to the issue?
Have you considered using lookups via Table.AddColumn instead of merges?
Hello,
thank you for this answer. I created two new columns by using
= Table.AddColumn("Table1", "New column name", each let match = Table.SelectRows("Table2", (x) => x[Merged] = [Account number]) in if Table.IsEmpty(match) then null else match{0} [Group name])
and now it's working.