All,
I am curious if there is a way to get a dynamic user input to change all unique values in a column. Lets's say the original data is the following:
Category | Data |
A | XXX |
C | XXX |
B | XXX |
D | XXX |
E | XXX |
A | XXX |
A | XXX |
B | XXX |
Is there a way to get an input box to show up that the user can rename each of the categories? What I want is something like:
Category | User Input Category |
A | [user inputs name here] |
B | [user inputs name here] |
C | [user inputs name here] |
D | [user inputs name here] |
E | [user inputs name here] |
I want this user input table to be dynamic if possible (i.e. accounts for different categories pulling in from input files, so 5 update values for A/B/C/D/E would not be sufficient). Is there a way to do this using the dynamic input tool or SQL?
Hi @abg5424
One way is to add it as a separate input file and using Find and Replace to overwrite.
Many thanks
Shanker V
Thanks! This is one thing I was trying but I was curious if there was a way to automatically change the separate input file based on what categories in the original inputs (i.e. if it has different categories than A, B, C, D, E). If we were instead given:
Category | Data |
A | XXX |
D | XXX |
G | XXX |
F | XXX |
G | XXX |
G | XXX |
A | XXX |
A | XXX |
Then the input table should instead automatically change to:
Category | User Input Category |
A | [user inputs name here] |
D | [user inputs name here] |
F | [user inputs name here] |
G | [user inputs name here] |