Yes it seem to be a simple job but I got stuck in it as data is multiplied with rows present in each excel sheet. For example if i have 30 rows each in each excel sheet then data was like 30*30*30. I tried to use tUnite but didnt solve this problem.
Here is an example:
I have a one big employee table in db whose data is coming from three sheets present in one xls file. Each employee data is divided according to categories in the separate sheets where each row of each sheet is representing one employee data.
Like
sheet1: firstname | lastname | email                                -----> (30 entries)
sheet2: designation | salary                                             -----> (30 entries)
sheet3: street | houseNumber | city | address1 | address2 -----> (30 entries)

and the end result should be like this:
firstname | lastname | email | designation | salary | street | houseNumber | city | address1 | address2   ---> (merged 30 entries of db)

Please help me how to merge the data in one row of db?
Thanks for your help.

Can anybody please help me how to the following scenerio?


tFileInputMSPositional -------> tExtractPositionalFields   ---------->
                                -------> tExtractPositionalFields   ---------->    tMap
                                -------> tExtractPositionalFields   ---------->

I am not been able to merge these three extracted fields in one tMap
Any help be appreciated. Thansk