Forum Discussion
jcastr02
Post Prodigy
Post ProdigyCombining certain columns from different queries
I have certain columns from 3 different queries where Im asking an NPS Question - 1 table is from 30 day , 1 table is from 60 day, and 1 table is from 90 day. How can I combine or append these colu...
Hi, jcastr02
Based on your description, I created data as follows.
You can click 'Edit Query', go to Query Editor, create a new Query, input the following codes in the 'Advanced Editor'.
let Source = Table.Combine({Table.AddColumn(Table1,"From",each "Table1"), Table.AddColumn(#"Table 2","From",each "Table2")}) in SourceResult:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-alq-msft
Community Support
Community SupportHi, jcastr02
Based on your description, I created data as follows.
You can click 'Edit Query', go to Query Editor, create a new Query, input the following codes in the 'Advanced Editor'.
let
Source = Table.Combine({Table.AddColumn(Table1,"From",each "Table1"), Table.AddColumn(#"Table 2","From",each "Table2")})
in
Source
Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.