Alteryx Designer Desktop Discussions

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

Import multiple CSV excel files with different sheet name

mihaicom20
8 - Asteroid

Hello everyone, 

 

I am trying to merge multiple excel files that have CSV extension and the sheet name is different for every file. The files schema is the same.

Is there any macro that can merge multiple CSV excel files? I tried to find smth similar on  community.

 

Thank you in advance!

 

4 REPLIES 4
binuacs
21 - Polaris
mihaicom20
8 - Asteroid

@binuacs I tried this kind of macro, but the problem is that I don't know how to apply it to CSV files

mihaicom20
8 - Asteroid

@binuacs I found this as a solution

binuacs
21 - Polaris

@mihaicom20 thanks I made some changes in the batch macro which i initially to only read .csv files with different sheet name 

Labels
Top Solution Authors