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", "Column7", "Column8", "Column9"}),

   #"STEP5" = Table.ReplaceValue(#"STEP4",null,"",Replacer.ReplaceValue,{"Column6", "Column7", "Column8", "Column9"})

 

    Desired result:

    #"STEP5"=Table.ReplaceValue(#"STEP4",null,"",Replacer.ReplaceValue,{"STEP4"})

 

As I am new to M, is it doable, please?

 

Thank you.

Need Help
Tips and Tricks

2 Replies

  • 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

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    You can do

    #"Step 4" = Table.ColumnNames(#"Step 3"[[Column 6], [Column 7], [Column 8], [Column 9]])


    #"STEP5"=Table.ReplaceValue(#"Step 3"[[Column 6], [Column 7], [Column 8], [Column 9]], null,"",Replacer.ReplaceValue,#"Step 4")

    --Nate