Rearrange columns as per the requirement

Question

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,

InputRequirementColumn NameColumn orderColumn NameLast Name1Name PrefixMiddle Name2First NameName Prefix3Middle NameFirst Name4Last NameName Suffix5Name SuffixDOB6GenderAddress 17Date of BirthAddress 28Address 1Gender9Address 2

Thanks
Naga

Dazzerman · Accepted Answer

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 Answer

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.