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

Question

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?

alexnajm · Answer

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

alexnajm · Answer

@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!

Prashant24 · Answer

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?