Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, if I have something like this:
Table1:
Fld, Pd, Val
A, 5-17, 1
B, 5-17, 1
C, 5-17, 2
D, 5-17, 3
Table 2:
Fld, Pd, Val
B, 5-18, 3
D, 5-18, 4
E, 5-18, 3
F, 5-18, 5
And I want to get only this in Table3:
B, 5-17, 1
B, 5-18, 3
D, 5-17, 3
D, 5-18, 4
Thanks
Message was edited by: Nenad Vuković to make it more realistic
Is there a smarter solution:
T1:
load * inline [
Fld, Pd, Val
A, 5-17, 1
B, 5-17, 1
C, 5-17, 2
D, 5-17, 3];
T2:
noconcatenate load * inline [
Fld, Fld1, Pd, Val
B, B, 5-18, 3
D, D, 5-18, 4
E, E, 5-18, 3
F, F, 5-18, 5]
where exists(Fld);
concatenate load * resident T1 where exists(Fld1, Fld);
drop table T1;
drop field Fld1;
try this
Table1:
l
A
B
C
D
inner join
Table2:
B
D
E
F
check this liknk
load * from Table1;
inner join
load * from Table2;
Is there a smarter solution:
T1:
load * inline [
Fld, Pd, Val
A, 5-17, 1
B, 5-17, 1
C, 5-17, 2
D, 5-17, 3];
T2:
noconcatenate load * inline [
Fld, Fld1, Pd, Val
B, B, 5-18, 3
D, D, 5-18, 4
E, E, 5-18, 3
F, F, 5-18, 5]
where exists(Fld);
concatenate load * resident T1 where exists(Fld1, Fld);
drop table T1;
drop field Fld1;