I got 2 files from source
Structure of File1 is
Col1 Col2 Col3
1 RS A
1 RD B
1 GD C
Structure of File2 is
Col1 Col5
1 TB
1 TB
By using above two files I have to create output file like
Output file structure
Col1 Col2 Col3 Col5
1 RS A TB
1 RD B TB
1 GD C
Can any one help me how to create output file Like above structure
Cheers,
A
Merge Duplicate Records
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Can be done without Remove Duplicate
This can be done using Merge stage and without removing Duplicate-
File1
Col1 Col2 Col3
1 RS A
1 RD B
1 GD C
File2
Col1 Col5
1 TB
1 TB
Use Merge stage with File2 on Master link and File1 on Update link. Set "Unmatched master mode" as "Drop". Key column - Col1.
Output
Col1 Col2 Col3 Col5
1 RS A TB
1 RD B TB
1 GD C TB
File1
Col1 Col2 Col3
1 RS A
1 RD B
1 GD C
File2
Col1 Col5
1 TB
1 TB
Use Merge stage with File2 on Master link and File1 on Update link. Set "Unmatched master mode" as "Drop". Key column - Col1.
Output
Col1 Col2 Col3 Col5
1 RS A TB
1 RD B TB
1 GD C TB