Forum Discussion

wollensack's avatar
wollensack
Frequent Visitor
3 years ago
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 4 columns (in a step called "Table2")

Columns are [1/09/2022] [1/10/2022] [1/11/2022] [1/12/2022]

Both steps only contains 1 row (for this scenario)

I now want to create a step that merges the columns from Step "Table1" and "Table2"

I also created 2 lists which stores the column names I require

 

The problem is that my attempt brings them together but gives me two rows.

 

I tried to use M code "= Table.SelectColumns(Table1,List1)&Table.SelectColumns(Table2,List)"

 

Output looks like this

StageInvoice  1/09/20221/10/2022  1/11/20221/12/2022
FirstB2348-B nullnullnullnull
nullnull23.5465.7687.2312.54

but should be this

StageInvoice  1/09/20221/10/2022  1/11/20221/12/2022
FirstB2348-B 23.5465.7687.2312.54

 

Hope I explained this enough

 

thankyou

Frank

2 Replies