Concatenating Fields With Same Data

[Anonymous]

I'm loading hundreds of CSV files into one QVD. Ideally, they all should have same column names but there are cases when files come in with different column names but same data to be concatenated. Is there a way to concatenate such fields while loading instead of wrting another piece of code?

I'm doing:

Main:

Concatenate Load *

From $(FilePath)*.CSV;

Store Main into FilePath\Main.QVD;

All CSV files are placed in one directory.

[#2]

Hi

Yes, don't use the name of column so if they change you don't care BUT in this case they have to keep the same position in the file.

regards

chris

[Anonymous]

I'm trying to achieve:

Main:

Concatenate Load *,

XYZ as Price

From $(FilePath)*.CSV;

Store Main into FilePath\Main.QVD;

And positions are not consistent.