Reference link data to be passed
Moderators: chulett, rschirm, roy
Reference link data to be passed
Hi All,
I have a requirment as below.
Main Link:
1
2
3
4
Reference Link:
1
2
3
5
1. After doing lookup i will pass the matched rows.
2. I will pass the unmatched rows from the main link by using reject option so that 4 record will pass.
3. My question here is i want to pass the unmatched row from the reference link to pass i.e 5 should be passed to a file. how can i do this..please let me know.
Thanks
Pavan
I have a requirment as below.
Main Link:
1
2
3
4
Reference Link:
1
2
3
5
1. After doing lookup i will pass the matched rows.
2. I will pass the unmatched rows from the main link by using reject option so that 4 record will pass.
3. My question here is i want to pass the unmatched row from the reference link to pass i.e 5 should be passed to a file. how can i do this..please let me know.
Thanks
Pavan
pavan
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
Pavan,
You need to be clear with your requirements. I know that you have 2 input files. How many output files you need and what do you need in them? Use your sample inputs and explain. Whatever, it is possible but you may end up using multiple merge stages (lookup/join).. sometimes multiple jobs. The solution depends on your requirements
You need to be clear with your requirements. I know that you have 2 input files. How many output files you need and what do you need in them? Use your sample inputs and explain. Whatever, it is possible but you may end up using multiple merge stages (lookup/join).. sometimes multiple jobs. The solution depends on your requirements
Kandy
_________________
Try and Try again…You will succeed atlast!!
_________________
Try and Try again…You will succeed atlast!!