Dynamic User Input Table in yxwz

Question

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:

CategoryDataAXXXCXXXBXXXDXXXEXXXAXXXAXXXBXXX

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:

CategoryUser Input CategoryA[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?

abg5424 · Answer

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:

CategoryDataAXXXDXXXGXXXFXXXGXXXGXXXAXXXAXXX

Then the input table should instead automatically change to:

CategoryUser Input CategoryA[user inputs name here]D[user inputs name here]F[user inputs name here]G[user inputs name here]

ShankerV · Answer

Hi @abg5424

One way is to add it as a separate input file and using Find and Replace to overwrite.

Many thanks

Shanker V