Forum Discussion
Solved
How to Replace in PQ without indicating Columns
Hello Everyone My table has a structure like A1 B1 C1 D1 1 Value1 OK OK 2 OK OK Value3 3t OK Value2 OK The thing is that the name columns cames from a Transpose...
NewStep=Table.ReplaceValue(PreviousStepName,"Value","No",(x,y,z)=>if Text.Contains(x,y) then z else x,Table.ColumnNames(PreviousStepName))
wdx223_Daniel
Community Champion
Community ChampionNewStep=Table.ReplaceValue(PreviousStepName,"Value","No",(x,y,z)=>if Text.Contains(x,y) then z else x,Table.ColumnNames(PreviousStepName))
Yep this can work, I will use my step where I list my columnnames. Thank you
