Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Venkatesh_5990
Contributor III
Contributor III

Show top 2 detailed level of data

I have a summary table like shown below 

Organizations Counts
TCS 5000
CTS 4000
HCL 3000
Wipro 2000

 

Here is the detailed level of data 

Detailed Table 1:

ORG Employee Name Count
TCS A 100
TCS B 90
TCS C 80
TCS D 70
TCS E 60

 

Detailed Table 2:

ORG Employee Name Count
CTS F 40
CTS G 30
CTS H 20
CTS I 10

 

The required output should be Details of top 2 ORGs. One table is TCS and other should be CTS. The output should be change dynamically as the count changes.

Employee Name Count
A 100
B 90
C 80
D 70
E 60

 

Employee Name Count
F 40
G 30
H 20
I 10

 

Labels (1)
0 Replies