This example convert 2 different recordsets inside single file to xml. First recordset is “SINGER”, second recordset is “SONG”. First column is 1 character length. It is a key column to identify different recordset. “A” from first half mean SINGER, “B” from second half mean SONG.
This is the target Message Type:
Below are the configuration that make this happen:
| ignoreRecordsetName | true |
| SINGER.fieldFixedLengths | 1,5,20 |
| SINGER.fieldNames | KEY,SINGERID,FULLNAME |
| SINGER.keyFieldValue | A |
| SINGER.keyFieldInStructure | ignore |
| SONG.fieldFixedLengths | 1,5,35 |
| SONG.fieldNames | KEY,SINGERID,SONGNAME |
| SONG.keyFieldValue | B |
| SONG.keyFieldInStructure | ignore |
Keep on posting!
File Adapter – Sender – Convert Multiple Fixed Length Structure to XML Using Key Field Name
Excellent demonstration of FCC in PI