Lookup file-> how do arrive this answer

[LavanyaRamesh007]

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??????

[ray.wurlod]

The Lookup stage has a drop down list of reference inputs. You can choose one from which multiple row returns is permitted.