Rearrange columns as per the requirement

[Naga]

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

[Dazzerman · Accepted 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.

[Dazzerman · Accepted solution]

I decided to add a RecordID Tool, and sort based on this as it is a more reliable method to ensure that the order values aren't duplicated.  This way you can remove the Column Order field in the Text Input, and just rely on the order of the fields within it instead.

[Naga]

Thanks Dazzerman for quick help. This solved my need...

[Dazzerman]

You're very welcome!  Glad this solution helped.  🙂