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