Discussion board where members can get started with Qlik Sense.
(ooxml, embedded labels, table is Sheet1);
below is Data
(ooxml, no labels, table is Sheet1);
Sample Data without header now.
I want to give the header such as col1 header will be SalesHeader table first column i.e col1 value like that all.
Sales Value Sales Qty Net Sales
Is it possible friends?? please suggest me. Thanks,
Go to Solution.
IS the Excel file your loading from have the column headers as col 1, col 2 etc with the values under them? If so you can skip the 1st line like this,
(ooxml, embedded labels, header is 1 lines, table is Sheet1);
you can use the rename function with a mapping load:
Mapping Load OldFieldName, NewFieldName From FieldNames ;
Rename Fields using FieldNameMap;
We can not write direct Query based on SalesHeader column name ??
Suppose I am loading SalesData table there Can it be possible to Assign column name as SalesHeader column values ??
, // Here I want assign column name will be SalesHeader Column value
Is it possible??
I am not sure I understand fully. How would you write the query to extract your data? From here I may be able to assist.