AnsweredAssumed Answered

How to handle multiple spreadsheet in excel through Boomi

Question asked by sundarmahalingam on Apr 22, 2016
Latest reply on Apr 22, 2016 by santosh.gunasekaran854179

I have a requirement where I need to handle multiple spreadsheet (Around 9 to 10 sheets) in an excel which I need to import and take the data and then use it to map in the destination profile.

Please do let me know if we can do it and what would be the best way to proceed in this scenario.

 

 

I need to map the data coming in the Excel to a flat file.

Say Excel has got each sheet with some code and name,

Sheet 1 - 100 (Personal)

Sheet 2 - 305 (Details)

and so on

 

I need to map it into a flat file which is comma separated file.

For an employee we would be mentioning it as,

 

"100","Person ID","First Name","LastName"

"305","Person ID","Address",...

So on

 

Please let me know what would be the effective way to proceed on this requirement.

 

Thank and Regards

Sundar Mahalingam

Outcomes