Have different csv files with column names and positions change

[Uday]

I have multiple csv files with columns Date, colum1, column2 in one csv and Date, column2, colum1, and Time, colum 1, column 2.... 

I have to check the column names and then remove or add spaces in the column name and if required change the column position.

Out of the mentioned scenarios I want the load to be done as "Date/Time, column1/column 1, column2/Column 2

Please help me

[Anil_Babu_Samineni]

Could you please explain in the data set?

[jonathandienst · Accepted solution]

For csv's with column names in the header, position is not important. For name differences, use something like:

Data:
LOAD Date as DateTime, 
	column1, 
	column2 
FROM ....

Concatenate(Data)
LOAD Time as DateTime, 
	[column 1] as column1, 
	[column 2] as column2
FROM ....