Hi All,
Need expert help on my requirement. I have a data file with 100 of fields and need to solve this using alteryx.
Problem statement: Data fields to be rearranged as per the standard requirement. The input, which I received will have columns in different position that needs to be arranged as per standard template.
Is there a way I can have the field mapped (input vs standard) in a excel file and give the numbering in which each column to be arranged. If so, let me know how I can achieve this using alteryx,
Input | Requirement | |
Column Name | Column order | Column Name |
Last Name | 1 | Name Prefix |
Middle Name | 2 | First Name |
Name Prefix | 3 | Middle Name |
First Name | 4 | Last Name |
Name Suffix | 5 | Name Suffix |
DOB | 6 | Gender |
Address 1 | 7 | Date of Birth |
Address 2 | 8 | Address 1 |
Gender | 9 | Address 2 |
Thanks
Naga
Solved! Go to Solution.
Hi @Naga,
Here is a workflow that will do the re-ordering for you.
You just need to change the Input to your data source, enter the list of fields in the order that you want, and then save the output in the format that you need.
I hope this helps.
Thanks Dazzerman for quick help. This solved my need...
You're very welcome! Glad this solution helped. 🙂