Hello
I have different input files with loads of columns.
I want to build an app that has 4 dropdowns (ID, Address, State, Postcode)
The user will select the fields that aligns to the 4 above and an output will be created.
Attaching a sample input file for reference.
Thanks in advance
Solved! Go to Solution.
I could partially understand the scenario. You want to select the columns that needs to be renamed to ID, Address, State, Postcode.
You can achieve this using the dynamic rename tool.
Workflow:
In dynamic rename tool I am creating a condition block saying replace the column selected for ID, Address, State, Postcode. Using drop tool I am passing the column that needs to be renamed in each scenario. And when the columns are mapped its renamed.
Output:
As you can see the selected column has been renamed since there is already columns existing with same name its renamed as suffix 2.
Hope this helps 🙂
Hey @atcodedog05
Thanks for your reply.
I don't want to rename but select only those 4 columns as output.
So the final output would be just ID, Address, State, Postcode.
Yeah the output is correct. But i don't need a select tool. It would be 4 *dropdowns* asking the user to select - ID, Address, State, Postcode
This is what i need
Here is how you can do it. I am using condition formula in dynamic select tool to select only specific columns. And these columns are updated by the list box.
Workflow:
Output:
Hope this helps 🙂
@atcodedog05 THanks thats exactly whats needed !
@atcodedog05 - one last request - How do we change the field names dynamically as well.
For example - In the screenshot above, I see you have selected "Name" as ID dropdown selection. In the Output as well, the Name field should be renamed to ID.
Thanks a lot for the help!