I have a look up file that has abbrevations for certain columns and their respective expansions..
my source need to look up on the abbrevations and need to fetch the expansions.. This is quite simple....
However in my scenario i have the same abbreviations that have multiple values..
eg.. NOL -NetPrice
NOL -NetIncome
NOL -NetLoss
I want all the multiple values in target... It can be fed as separate records like 3 values of NOL.. How do i arrive this??????
Lookup file-> how do arrive this answer
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 42
- Joined: Mon Apr 21, 2008 1:49 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: