Forum Discussion
Code to replace more than 1 value in a column
Hi all,
Do you have any suggestion code/script that I can use to replace all of below value simultaneously beside replace the column value 1 by 1.
PAR01 - 1
PAR02 - 2
PAR03 - 3
PAR04 - 4
PAR05 - 5
PAR06 - 6
Regards,
Nuha
Anonymous For this example it looks like you can use an extract - Last characters. It's in the transform tab, near the replace values button.
Otherwise you can use a mapping/lookup table and Merge Queries.
3 Replies
Anonymous For this example it looks like you can use an extract - Last characters. It's in the transform tab, near the replace values button.
Otherwise you can use a mapping/lookup table and Merge Queries.
Hi AllisonKennedy ,
Thank you for your support. Currently I use the extract - Last characters.
How about if all the data is not in sequence, for example below data. Do you have any specific code/script?
PAR - 1
LAN - 2
NAT - 3
KOL - 4
YTY - 5
ERT - 6
Regards,
Nuha
Anonymous , Sorry, I don't understand what you mean by not in sequence and what you want as a result?