Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.