Help Required
Moderators: chulett, rschirm, roy
Help Required
Hi all,
I have a requirement which needs to be handled in the datastage.
i/p
KEY1 KEY2 COL1 COL2 COL3 COL4 COL5 COL6 COL7
1 1 NULL NULL NULL MFS NULL NULL NULL
1 2 A7C NULL NULL NULL NULL NULL NULL
2 1 NULL MFG NULL NULL NULL NULL NULL
2 2 NULL NULL XXX NULL NULL NULL NULL
2 3 NULL NULL NULL NULL IPC NULL NULL
o/p
KEY1 COL1 COL2 COL3 COL4 COL5 COL6 COL7
1 A7C NULL NULL MFS NULL NULL NULL
2 NULL MFG XXX NULL IPC NULL NULL
The datatype of all the above columns mentioned is Varchar
Please help me in achieving the above logic
Regards,
Balakrishna
I have a requirement which needs to be handled in the datastage.
i/p
KEY1 KEY2 COL1 COL2 COL3 COL4 COL5 COL6 COL7
1 1 NULL NULL NULL MFS NULL NULL NULL
1 2 A7C NULL NULL NULL NULL NULL NULL
2 1 NULL MFG NULL NULL NULL NULL NULL
2 2 NULL NULL XXX NULL NULL NULL NULL
2 3 NULL NULL NULL NULL IPC NULL NULL
o/p
KEY1 COL1 COL2 COL3 COL4 COL5 COL6 COL7
1 A7C NULL NULL MFS NULL NULL NULL
2 NULL MFG XXX NULL IPC NULL NULL
The datatype of all the above columns mentioned is Varchar
Please help me in achieving the above logic
Regards,
Balakrishna
ok fine here goes the requirement
I have a key column (KEY1 and KEY2).For a particular record only one value exist under a single column.I need to group the records based on the key column(KEY1) and we need to merge the multiple records for that particulat Key column to a single record with the Column values of individual records in that particular group(for ex:KEY1=1) populated in the single record.
Regards,
Balakrishna
I have a key column (KEY1 and KEY2).For a particular record only one value exist under a single column.I need to group the records based on the key column(KEY1) and we need to merge the multiple records for that particulat Key column to a single record with the Column values of individual records in that particular group(for ex:KEY1=1) populated in the single record.
Regards,
Balakrishna
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI