Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Macro covert files (csv and xlsb) to xlsx format

SH_94
11 - Bolide

Hi Community,

 

I would like to ask if we can convert multiples file (csv and xlsb format) into xlsx file in the Alteryx by using macro. Understand that batch macro able to read multiple tabs in xlsx but only can read one tab for csv. While for xlsb , batch macro only able to read same sheet name for each excel file. Due to this limitation, i would like to convert all my csv and xlsb file into xlsx format before asking alteryx to read the data. 

 

Currently, i have four huge folders which consist of the following excel file format:

1. Folders consist of csv format only (different schema and different sheet name within one excel file)

2. Folders consist of xlsb format only (different schema and different sheet name within one excel file)

3. Folders consist of csv and xlsb format (mixture of these two format - different schema and different sheet name within one excel file)

4. Folders consist of csv, xlsb and xlsx (mixture of these three format - different schema and different sheet name within one excel file)

 

For items number 4, i plan to ask Alteryx to read all the files so that the output (xlsx) will be in one location.

 

May i know if this is possible in Alteryx to just convert all the files into xlsx format?

 

 

Many thanks for the helps.

3 REPLIES 3
joshbennett
11 - Bolide
11 - Bolide

Hi @SH_94 

 

A few things:

 

I hope that helps!

SH_94
11 - Bolide

Hi @joshbennett ,

 

Thank you for your prompt response.

 

1. In regards to the first point, i just checked my folders and noted that some of tabs were missing despite was saved previously. Thanks a lot for raising this point. 

 

2. I have the installed driver as per the post.

 

3. I did try the workflow and it seems to be quite hard to customise as i not so understand how to edit the workflow accordingly. 

 

May i know do you have any macro in your hands to convert it to xlsx format which can accommodate the following criteria?

1. Folders consist of csv format only (different schema for each file)

2. Folders consist of xlsb format only (different schema and different sheet name within one excel file)

3. Folders consist of csv and xlsb format (mixture of these two format - different schema for each excel file)

4. Folders consist of csv, xlsb and xlsx (mixture of these three format - different schema for each excel file).

 

 

Thank you for your help again

joshbennett
11 - Bolide
11 - Bolide

Hmm, for your question #3 - what exactly are you struggling with on that macro?

 

You can essentially just point the configuration to wherever your .xlsb files are saved:

joshbennett_0-1617675358070.png

 

 

...select the .xlsb file type in the Options (customizing the additional optional configurations as needed depending on whether you want the macro to extract the actual sheet data from each workbook or just metadata :

joshbennett_1-1617675407155.png

 

 

...and then run the workflow to have it pull data as specified from those .xlsb files.

 

For your .csv needs, you'd probably just need to create a separate batch macro for handling those. Have you ever built a batch macro before? If not, try reading through the available documentation here (https://help.alteryx.com/current/designer/batch-macro) and/or watching some of the interactive instructional videos here (https://community.alteryx.com/t5/Interactive-Lessons/Creating-a-Batch-Macro/ta-p/657923) and let me know if you have any specific questions implementing these concepts.

Labels