Creating an app that gives the output fields you select under multiple dropdown
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This is what i need
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@atcodedog05 THanks thats exactly whats needed !
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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!