CSV Batch Macro Error

[SH_94]

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.

[Luke_C · Accepted solution]

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.

[SH_94]

Hi @Luke_C ,

Thanks a lot for the guidance and help on this.

Appreciate it a lot

[SH_94]

Hi @Luke_C ,

Sorry to ask you the question again on the text to column input.

As i use the delimiters " ," in the text to column tools, all the data which contain "," will be split further again The result will be as follow. Is there anyway for us to split the column based on header only ?

Thanks a lot again for your guidance

[Luke_C]

Hi @SH_94 I'm not following the question. I think you would need to tell alteryx how the file is delimited. The headers and the data should typically use the same delimiter.

[omkarshinde]

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