Forum Discussion

Moonlight987's avatar
Moonlight987
Frequent Visitor
3 years ago

Referencing columns from previous step dynamically (M Code)

Hi Community,    in M, instead of mentioning particular columns in STEP5, I would rather make some reference to previous step.       Current:    #"STEP4" = Table.SelectColumns(#"STEP3",{"Column6...
Need Help
Tips and Tricks
ppm1's avatar
ppm1
Icon for Solution Sage rankSolution Sage
3 years ago

You can use Table.ColumnNames() for that. Example below.

 

#"STEP5"=Table.ReplaceValue(#"STEP4",null,"",Replacer.ReplaceValue,List.LastN(Table.ColumnNames(#"STEP4"), 4))

 

Pat