We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

how to divide files to different folders based on number of columns the files have

ewang
7 - Meteor

Hi there,

 

I have a folder which contains 100 files, and I need to parse all of them and get the output together. However, 70 of those files have 15 columns while the other 30 have 10 columns. In this case, my batch macro fail to parse the 30 files which have 10 columns because the schema mismatch.

 

I am thinking of bucket these 100 files to 2 sub folders, one to put in the 70 files have 15 columns and one to put in the 30 files that have 10 columns, so I can have batch marco to go through these 2 sub folders separately.

 

Does anyone have any idea how to do that? or is there a better suggestion how to parse these 100 files?

 

Thank you very much in advance.

 

 

3 REPLIES 3
mbarone
15 - Aurora
15 - Aurora

Do you want to simply stack them, regardless of the different schema?  That can be done in your batch macro settings, so that it will work just like a union tool.  If so, go to the View Interface Designer window, Properties (the gear icon), and click the option to configure based on name.

ewang
7 - Meteor

That does the trick, thanks. 

mbarone
15 - Aurora
15 - Aurora

Great.

Labels