Can anyone please brief me how to use Merge Stage pluggin in my job.
I tried to merge 2 distinct records from 2 files of the same columns.
I am using Join Type: Complete Set. My mapping column key is clientid.(Actually, I dun have a key to join.. but I am forced to enter)
For my input column map, I do not know which file columns shld i put bcos i am combining 2 files of diff records. I can't put the columns from file 1 nor columns from file 2. When I run this job, I keep getting error :
MergeClientRecords..Merge_2LA_And_2L: first file column 'clientid' must be present in output column list
Or
MergeClientRecords..Merge_2LA_And_2L: second file column 'clientid' must be present in output column list
Please help. Thanz a great lot.
Error when execute jobs with Merge Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 74
- Joined: Tue Sep 30, 2003 4:25 am
- Location: Malaysia