How to use List function to replace multiple columns in one step

[Anonymous]

Hello Geniues, need your help!

I have three tables with default value 0, and i wanna replace to different values per column. 

For instance: i have 1,2,3 columns, wanna replace the value as A,B,C separately per column, how can i do it in one step? with List function?

Really appreciate your help!

Br,

Ranwen

[Vijay_A_Verma · Accepted solution]

Try following (Razon has English o, so you will need to replace it appropriately)

= Table.TransformColumns(#"Source",{{"RUC EMISOR", each if _="0" then "A" else _},{"DVREL RUC", each if _="0" then "B" else _},{"RAZon Social EMISOR", each if _="0" then "C" else _}})

There are other approaches available as well but building in one single step as per your requirement is complex.

[Anonymous]

thank you!