Hi all,
I am wondering if there is any tool similar to "select", which would display a table with the unique values in a column and then would allow to rename them?
What I want to achieve is something similar to this:
Considering a simple table,
Number | Code |
1 | A |
2 | B |
3 | C |
4 | D |
A will be transformed to UK, B to FR, C to BE, and D to CZ,
Number | Code |
1 | UK |
2 | FR |
3 | BE |
4 | CZ |
I know this can be achieved with a formula block, but in my original data I have to do >150 conversions, and using formulas does not seem too efficient.
I am also thinking about some sort of lookup table, but that would require firstly the construction of that lookup table, which does not seem too efficient either.
Cheers
Solved! Go to Solution.
@omar_velor if this is a one off, then I would use a summarise tool to generate the unique list of value pairs. You can then copy this into a text input (or excel file if you wish to retain it) and then update the new names there. The interface of a text input is about as close to what you're after.
You can then use this lookup to either join or use a find and replace tool to update your original data - Find and replace is more performant, but only works with string fields and on single 'find' column. Join tools are more flexible, so it depends on your use case.
Hope that helps,
Ollie
Everyone has suggested great solutions, but yours answers exactly my question!
The Text Input is quite useful since more people will be looking at the workflow and different options (columns) can be added by each user.
Really appreciate it