Batch Macro Input for csv

[SH_94]

Hi Community,

I would like to ask if the sheetname for each csv files must be the same when we using the batch macro. It is because i know that xlsx format , the macro able to read each sheetname dynamically while xlsb need all the sheetname to be the same.

Thank you so much for your help.

[Shalz]

Hi,

  CSV files dont have a sheetname. Macro can be configured as updating input file in the action for control parameter and one for delimeter. Please see the attached file for reference

[SH_94]

Hi @Shalz ,

Could you share the workflow on the CSV macro input for my analysis?

Thank you.

[Shalz]

this has the macro too