Forum Discussion
JOSELUISMTZRMZ1
Helper I
Helper IHow 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))
Nathaniel_C
Community Champion
Community ChampionHi JOSELUISMTZRMZ1 ,
Please try this.
Replace Value with NO then in all the columns Extract first 2 characters.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
JOSELUISMTZRMZ1Nice try, but still having column names in formula which won't work on my case after.