DataStage Scenario - Problem21

Input Table 1

Col1	Col2
A	11
B	23
C
D	45

Input Table 2

Col1	Col2
X	34
Y	64
Z	23
A	143
B	56
C	77

Output Table

Col1	Col2
X	34
Y	64
Z	23
A	11
B	23
C	77
D	45

Like the Facebook Page & join Group
https://www.facebook.com/DataStage4you
https://www.facebook.com/groups/DataStage4you
https://twitter.com/datastage4you
https://groups.google.com/d/forum/datastage4you
For WHATSAPP group , drop a msg to 91-88-00-906098