Handling Excel split rows in a Composer transformation map

[placlef]

How can I code a transformation map to read the split rows?
Input is Excel xlsx with one row split into multiple rows.
I need to read the first line and insert it into the LANSA parent file. Then read all the split rows (from KM-BPR5ES to KM-FXT00V-CS00S) and insert them into the LANSA child file.
Thanks in advance for any input.

Here are screen shots:

How can I code a transformation map to read the split rows.docx

(108.82 KiB) Downloaded 1028 times

[JamesDuignan]

Hi Pat,

This very much is possible to do and looking and the snippet from the document you are definitely on the right track.

Can you let me know what is occurring when you try to run this map?

Also, in Mapforce when you switch to the output tab what is displayed?

mapforceoutput.PNG (17.8 KiB) Viewed 4663 times

Cheers,

James

[placlef]

Thanks, James for replying. Since my initial post, I have done more research and consulting. Apparently, the solution is to convert Excel file from xlxs to CSV format. MapForce has a feature called FlexText that allows to manipulate the incoming file (text and CSV format). I created a solution that I started to test, with no successful outcome yet.