Forum Discussion
Solved
How to join column data from 2 separate steps
"Data1" is a source file that contains over 40 columns I have created code that dynamically retrieves 2 columns (in a step called "Table1) Columns are [Stage] [Invoice] Second step retrieves...
Use this
=Table.FromColumns(Table.ToColumns(Table.SelectColumns(Table1,List1))&Table.ToColumns(Table.SelectColumns(Table2,List)), List1&List)👍 It's been a pleasure to help you | Help Hours: 11 AM to 9 PM (UTC+05:30)
How to get your questions answered quickly -- How to provide sample data
if these two table come from same soure, try this
=Table.SelectColumns(Data1,list1&list2)
Use this
=Table.FromColumns(Table.ToColumns(Table.SelectColumns(Table1,List1))&Table.ToColumns(Table.SelectColumns(Table2,List)), List1&List)👍 It's been a pleasure to help you | Help Hours: 11 AM to 9 PM (UTC+05:30)
How to get your questions answered quickly -- How to provide sample data