Source table with changing column names

[Eki]

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?

[MindaugasBacius]

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

[pasi_lehtinen]

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.

[Eki]

Hi

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.