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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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;