Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;