topic Re: Source table with changing column names in QlikView

Source table with changing column names

Eki — Wed, 25 Nov 2020 16:16:04 GMT

I have a souce table (csv) with some changing column names. Names are changing every week. (Those columns contains weekly work load). How I can refer/load data from these columns easily?

Re: Source table with changing column names

MindaugasBacius — Wed, 30 Jan 2019 07:55:38 GMT

Could you provide us two csv files that have different column names that we could play with?
What columns do you actually need?
Thank you

Re: Source table with changing column names

pasi_lehtinen — Wed, 30 Jan 2019 08:27:39 GMT

You can use:

Table:

Load * from DataSource;

This would create issues in case you need to concatenate data sets from files with different column names. Unless if you want to store each file data into a new column.

Otherwise you could use something like:

Table: //Create dummy table with required column names

Load * Inline [

Col1, Col2, Col3,...

];

Concatenate(Table)

Load

@1 as Col1,

@2 as Col2,

@3 as Col3,

...

From DataSource;

//Also you can add "for each" -loop in order to loop all necessary csv files dynamically.

Re: Source table with changing column names

Eki — Wed, 30 Jan 2019 10:15:14 GMT

Here is two files from same file with different column headers in workload section (BA->). I would like to keep those header informatiion in Qlik.