Hi,
I have a txt file as an input to my transform and the format of the text file is:

HEAD ABS 04172011
12345 salestax IL 12.50
23456 VATtax IL 12.50
FOOT 2 25

My objective is to convert this txt file into XML for further processing.

I created a transform (fixed width to XML) and created a dictionary for this file. I am able to fetch the data from first row(Head) and last row (foot) as I defined the RecordLayout with type = HEAD and FOOT respectively. The data in middle rows start with different values.

What is the type I need to use for the LOOP->RecordLayout structure to fetch the middle rows dynamically? Is there any other alternative in iSM to achieve this?

Thanks.

I think you have to have a record type for every row for fixed width input files. You will need to define it somehow for the data records.