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 [VALUE1,2,3,4,5,6,7,8];
lOAD * INLINE [VALUE1,2,3,9,10,11,20,26];
lOAD * INLINE [VALUE9,11,5,12,14,16];
lOAD * INLINE [VALUE14,7,11,24,25];
Result:NoConcatenateLoad VALUE where RepeatTime = 1;Load VALUE, count(RowNo()) as RepeatTime resident T1 group by VALUE;drop tables T1;