Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Mahamed_Qlik
Specialist
Specialist

Hi

Hi 

I have below two tables:

Table 1:

ID CODE
1 11AA
1 12AA
2 13AA
2 14AA
2 15AA

 

Table 2:

CODE DESC
11AA ENGLISH
12AA SPANISH
13AA ARABIC

 

 

When we are connecting these table we are getting below result:

ID CODE CODE DESC
1 11AA 11AA ENGLISH
1 12AA 12AA SPANISH
2 13AA 13AA ARABIC
2 14AA    
2 15AA    

 

We need below result:

 

ID DESC1 DESC2
1 ENGLISH SPANISH

 

So in short we want to create multiple description filed for each ID to display as column in table object not pivot table.

 

 

Labels (1)
2 Replies
Chanty4u
MVP
MVP

Try this script 

JoinTable:

LOAD

  ID,

  CODE,

  DESC

RESIDENT Table1

LEFT JOIN

(Table2)

 

ON CODE;

 

To display the descriptions as separate columns, use calculated dimensions. Create two calculated dimensions .

 

For DESC1: if(rowno()=1, DESC)

For DESC2: if(rowno()=2, DESC)

Mahamed_Qlik
Specialist
Specialist
Author

we can not give rowno() as 1,2,3, becasue what if we have 10 rows.