Referencing columns from previous step dynamically (M Code)

[Moonlight987]

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.

[Anonymous]

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

[ppm1]

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

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

Pat