TableRightJoin:
//NoConcatenate
Load * inline
[
A,B,C
1,aa,e
2,bb,f
3,cc,g
4,dd
]
;
Right Join(TableRightJoin)
TabRightJoin:
Load * inline
[
A,B,C
e,xx,x
f,yy,y
g,cc,z
5,tt
]
;
QUALIFY *;
TabRightJoin:
Load * Resident TableRightJoin;
UNQUALIFY *;
DROP Table TableRightJoin;
Exit Script;
My Output:
e xx
f yy
g cc
5 tt
On what basis is the result working ? as the qualify *; is present I believe all the fields from table2 must come right?
e xx x
f yy y
g cc z
