Creating an app that gives the output fields you select under multiple dropdown

[E_Sinha_home]

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

[atcodedog05]

Hi @E_Sinha_home 

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 🙂

[E_Sinha_home]

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.

[atcodedog05]

Hi @E_Sinha_home 

Are you looking for something like this.

Workflow:

Hope this helps 🙂

[E_Sinha_home]

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

[E_Sinha_home]

This is what i need

[atcodedog05 · Accepted solution]

Hi @E_Sinha_home 

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 🙂

[E_Sinha_home]

@atcodedog05 THanks thats exactly whats needed !

[atcodedog05]

@E_Sinha_home 

Glad we were able to solve the problem statement 🙂 Happy to help 🙂

[E_Sinha_home]

@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!