Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want give table header based on other table record in qliksense
Here I have given the sample data .
Table1:
column1 , column2,column3
2009 , Q1 , 100
2010, Q2, 200
2011, Q3, 400
Table2:
No , Header
column1,Year
column2,Quarter
column3, Sales
Output :
Year , Quarter,Sales
2009 , Q1 , 100
2010, Q2, 200
2011, Q3, 400
Load column1 , column2,column3 from table1;
FieldsMap:
Mapping load No , Header from table2;
Rename fields using FieldsMap;