Search found 2 matches
- Wed Nov 15, 2017 6:58 am
- Forum: Questions & Answers
- Topic: Handling Excel split rows in a Composer transformation map
- Replies: 2
- Views: 4691
Re: Handling Excel split rows in a Composer transformation map
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 ...
- Sat Nov 04, 2017 2:37 am
- Forum: Questions & Answers
- Topic: Handling Excel split rows in a Composer transformation map
- Replies: 2
- Views: 4691
Handling Excel split rows in a Composer transformation map
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 ...
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 ...