Multiple similar file but structure is not consistent

I'm trying to build a macro off a few files, but for one of the input file, the structure and header is not always the same. Few variation of the file, would an empty row above the header, header naming is slightly off, or table start in column B instead of A.

Is there a way for Alteryx to format the structure if I were to somehow provide a template for it to follow? See attached mockup.

Thanks in advance.

testformat.yxmd

Input

Accepted answers

binu_acs

@dchin try the below method, this might be working for your use-case

testformat.yxzp

All comments

binu_acs

@dchin in your desired template what would be the actual column names? is it the below ones

dchin

Yes, the headers should be the below. But sometimes I receive files with a slight variation like the one listed under "version 2" sample.

Order ID

Order Date

Customer ID

Segment

binu_acs

@dchin try the below method, this might be working for your use-case

testformat.yxzp

dchin

Thank you! This works if I were to manually input the file. Is there a way to run this automatically?

For instance, I want to create the workflow where user will drop the input file into a folder. Then have Alteryx pick up that file from the folder and it will basically determine which version to run whether it version 1,2, or 3.

binu_acs

@dchin If the column names are same in all the input file I think you can use this workflow, this should work all your given scnario, one thing is you need to mention only the field names in a given file

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703