Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Rajkumar
Creator
Creator

How Assign column name from separate table in qlik

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

1 Reply
Vegar
MVP
MVP

Load column1 , column2,column3 from table1;

FieldsMap:

Mapping load No , Header from table2;

Rename fields using FieldsMap;