CSV Batch Macro Error

Hi Community,

I have built the batch macro input for CSV file based on the concept of xlsx but it seem like not working in this case as it show the error as below. Could anyone can help me to look into the alteryx solution and guide me which part need to be amended?

Basically i would like to ask the alteryx to read the csv file (which is different schema) and extract the following data

1. File name for each csv file

2. Each tab name for each csv file

Thank you so much for your help.

VA Checking 2.yxzp

Common Use Cases

Accepted answers

Luke_C

Hi @SH_94

Give this a try, it should work after I cut out a lot of the unneeded macros around sheets. If you're all set please be sure to accept the solution.

VA Checking 2.yxzp

Luke_C

In the input, deselect 'first row contains field names' so you can split them with the text to columns. then use dynamic rename to use the first row as the data. See attached sample. Hope this solves the problem.

New Workflow4.yxmd

All comments

Luke_C

Hi @SH_94

Part of the problem is that csv files don't have sheet names, they are just text files at their core. If you really just need the file name the directory tool alone should work

SH_94

Hi @Luke_C ,

Thank you for your swift response.For the directory tools, will it work if i have the CSV file with different schema? Could you show me how it need to be amended in the workflow to deal with different schema files.

Thank you.

omkarshinde

@Luke_C any way to add filename as extra column with every record while reading multiple files via this batch macro?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703