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.
SOLVED

Automatically reading many csv files

Saraabdi955
8 - Asteroid

Hi
How can I automatically read a large number of csv files (over 1000 files) with completely different columns and separators and union them then put them in a table?

16 REPLIES 16
Saraabdi955
8 - Asteroid

Hi,

Thank you for recommending me to study about this.

But now I have a problem:

when I have a new column in a file, I get an error and I can not give an output ...

Thank you for helping me

messi007
15 - Aurora
15 - Aurora

@Saraabdi955,

 

Could you share the macro or the workflow you're using in order to help you.

 

Regards,

Saraabdi955
8 - Asteroid

Of course,

Thanks a lot

messi007
15 - Aurora
15 - Aurora

@Saraabdi955,

 

Have you selected the option below in the macro:

 

messi007_0-1609940623934.png

I have tested with 3 files with different schema and it works for me.

 

Attached the workflow,

 

Hope that helps!

 

Regards,

Saraabdi955
8 - Asteroid

right, it's Ok ...

Thanks a lot.

Also about different delimiters, is it necessary to determine delimiters of each file?

Can we OR any delimiters to automate reading any file with any delimiters?

messi007
15 - Aurora
15 - Aurora

@Saraabdi955,

 

As I know you have to specify the delimiter of each file.

 

Hope that helps!

 

Regards, 

Saraabdi955
8 - Asteroid

Thanks a lot,

Regards.

 

Labels