Scenario

[sonalimss]

hai Guy's

there are three inputs files with same InvoiceNumber

first Input :

1001,abc,xyz
1002,jkl,qwe
1003,ert,yui

2nd Input :

1001,Address
1001,Address1
1002,USA
1003,INDIA

3rd input :

1001,Items
1002,PEN
1003,BOX

i need an output as

1001,abc,xyz
Address
Address1
Items

1002,jkl,qwe
USA
PEN

1003,ert,yui
INDIA
BOX

Plz help me out in extracting these record's as desired (Output)

Thanks....

 

[janhes]

I think you've already asked this.

 

[mladd]

Plz help me out in extracting these record's as desired (Output)

I believe your answer is in your request.

EXTRACT() may accomplish what you want to do here. In the output you can grab the UNIQUE invoice numbers (1001) then call a F_Map using the EXTRACT function to grab all of the records from the 3 inputs that match the UNIQUE invoice number.

It's just a thought, but this is kind of how I create order status files for customers with multiple orders, multiple order details for each order and multiple status for each detail.