topic Re: Concatenating Fields With Same Data in QlikView

Concatenating Fields With Same Data

Anonymous — Tue, 26 Mar 2013 15:07:36 GMT

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.

Re: Concatenating Fields With Same Data

Tue, 26 Mar 2013 15:09:47 GMT

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

Re: Concatenating Fields With Same Data

Anonymous — Tue, 26 Mar 2013 15:18:30 GMT

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.