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: 
qvqfqlik
Creator
Creator

Need help with table data

please help with below problem:

I have four tables and need to get a final table as below:

Below is the sample data:

table1 :  field values - 1,2,3,4,5,6,7,8

table2: field values - 1,2,3,9,10,11,20,26

table3: field values- 9, 11,5, 12,14,16

table4: field values - 14,7,11,24,25

values to get in Final table required output:  4,6,8,10,20,26,12,16,24,25

Eg:

for example, I need to get all the data that will fall under the white area in the circles of the below image

vd.jpg

 

1 Reply
thi_pham
Creator III
Creator III


T1:
lOAD * INLINE [
VALUE
1,
2,
3,
4,
5,
6,
7,
8
];

lOAD * INLINE [
VALUE
1,
2,
3,
9,
10,
11,
20,
26
]
;


lOAD * INLINE [
VALUE
9,
11,
5,
12,
14,
16
];

lOAD * INLINE [
VALUE
14,
7,
11,
24,
25
];

Result:
NoConcatenate
Load VALUE where RepeatTime = 1;
Load VALUE, count(RowNo()) as RepeatTime resident T1 group by VALUE
;
drop tables T1;