Rearrange columns as per the requirement
- 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
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.
- Labels:
- Help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- 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
Thanks Dazzerman for quick help. This solved my need...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You're very welcome! Glad this solution helped. 🙂
