Hi,
I have tried to use Merge stage as follows, but the output is coming as NULLs for
other selected merge columns. ( I have Sort asc before the Merge stage)
Input 1
C1 C2 C3
--------------
1 a 10
2 b 20
Input 2
C1 C2 C4
-------------
1 a 100
2 b 200
Input 3
C1 C2 C5
--------------
1 a 1000
2 b 2000
Output- Present
C1 C2 C3 C4 C5
------------------------------------
1 a 10 NULL NULL
2 b 20 NULL NULL
Expected is
C1 C2 C3 C4 C5
------------------------------------
1 a 10 100 1000
2 b 20 200 2000
Could you please help me on getting this with help of Merge stage?
Thank you
lkganta
Merge stage with NULL output
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 251
- Joined: Mon Jun 09, 2008 5:52 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 251
- Joined: Mon Jun 09, 2008 5:52 am