Automatically reading many csv files

[Saraabdi955]

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?

[Saraabdi955]

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]

@Saraabdi955,

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

Regards,

[Saraabdi955]

Of course,

Thanks a lot

[messi007 · Accepted solution]

@Saraabdi955,

Have you selected the option below in the macro:

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

Attached the workflow,

Hope that helps!

Regards,

[Saraabdi955]

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]

@Saraabdi955,

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

Hope that helps!

Regards, 

[Saraabdi955]

Thanks a lot,

Regards.