If we have multiple csv files and other csv files are getting added up?

[Prashant24]

How to create wf for this scenario? If we have multiple csv files and other csv files are getting added up weekly and these files are not having any column header so how can we convert them into single excel file such that future data also gets added up?

[Prashant24]

If we have multiple csv files and other csv files are getting added up weekly and these files are not having any column header so how can we convert them into single excel file such that future data also gets added up?

[alexnajm]

Have you tried using the wildcard feature? It’s detailed here: https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309

[alexnajm]

As long as those files are added to the same folder each time and have the same structure, they should just stack altogether

[Prashant24]

Thanks Alex naam for the response I was able to get the single xlxs file using the wildcard function, but the problem that I am facing is with the column header since these files are not having header so it is not coming up in output file as well.

How can we add the column header in the output file also for future do I need to select append with existing data in the output tool?

[alexnajm]

@Prashant24 if the files don’t have a header in the first place, then you can create header names via a Select tool. 

if you are saying your first row contains data, there is a setting in the input data tool to check off!

[alexnajm]

If you need further help, then sample files will be needed