Visual LANSA Forum

Hi,

This is a LANSA Composer question. Since I could not find the forum for LANSA Composer, can I ask you a question here?

<details>
I would like to convert data and add records from Excel file to a physical file on IBM i. I would like to do the following three with the conversion map(Altova MapForce).

1) I would like to add branch numbers in sequence, if Excel's A columns value are the same. I would like to count up and add a branch number while the value of column are the same.
2) I want to count up again from 1 when the counted up value reaches 99.

I will send you the sample Excel files. Please see attached files.
SAMPLE.xlsx : Sample data
SAMPLE2.xlsx : I would like to add branch numbers like this and update to file on IBM i.

I think it is necessary to hold the value of column A and a branch number of the previous record, and compare with the value of column A of the next record, and count up a branch number by the Altova MapForce.
I do not know how to hold the value of the previous record.

<questions>
Can I hold the value of the previous record, and compare and countup in the next record with the conversion map(Altova MapForce)?


Best regards,
Rieko Saitoh
LANSA japan

Hi Riecko,

As this is a question of how can I achieve this in Mapforce, I suggest that you post this on the Mapforce user forum found here: https://www.altova.com/forum/default.aspx?g=topics&f=38

There are a lot of very well versed Mapforce users active on that forum and this would be the best place to get guidance on your question.

Regards,

James

Hi,

James, thank you for the advice. I asked the question to Altova support, and I was able to achieve my purpose. The method is as follows.

1) Using 'auto-number' function.
http://manual.altova.com/Mapforce/mapfo ... number.htm

2) Building logic using multiple functions.

Thank you.

Best regards,
Rieko Saitoh
LANSA japan