Need help with table data

qvqfqlik — Fri, 17 Jan 2020 06:35:22 GMT

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

Re: Need help with table data

thi_pham — Fri, 17 Jan 2020 07:12:38 GMT

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;