Help needed in message mapping

[ADIDAS]

Hi,

We have a Flat file message coming in with the structure mentioned below: The segments *Record, ItemData1 and ItemData2* are flat structures of the *Recordset*.

Recordset - Occurs 1

-- Record - Occurs N

-- ItemData1 - Occurs N

-- ItemData2 - Occurs N

Ex:

Recordset

--REC1

--IDATA1R11

--IDATA1R12

--IDATA1R13

--IDATA2R11

--IDATA2R12

--IDATA2R13

--REC2

--IDATA1R21

--IDATA1R22

--IDATA2R21

--IDATA2R22

.....

This needs to be mapped to a nested structure mentioned below. The *Itemdata1 and Itemdata2* segments are part of *Record*

Recordset - Occurs 1.

-- Record - Occurs N

-

---

ItemData1 - Occurs N

-

---

ItemData2 - Occurs N

Ex:

--REC1

-

---

IDATA1R11

-

---

IDATA1R12

-

---

IDATA1R13

-

---

IDATA2R11

-

---

IDATA2R12

-

---

IDATA2R13

--REC2

-

---

IDATA1R21

-

---

IDATA1R22

-

---

IDATA2R21

-

---

IDATA2R22

.......

The problem we have is we donot have a key linking the ItemData1 and ItemData2 with the Record and we need to fillup the nested structure based on the values coming .

Any idea how we can achive this.

Regards,

Arunava

[Former Member]

Hi Arunava,

First of all it would be good if you can provide information on flat file.

How it is structures, I mean whether file is coming with comma separated fields ?

And how you separate ITEMDATA1 and ITEMDATA2?

If file is not coming as comma separated values then you can use FieldFixedLengths to distinguish structure.

It would be good if you can give us sample file input.

Best Regards,

Divyesh Vasani

[Former Member]

Hi Arunava,

If you dont have any key field in ItemData1 and ItemData2 in the incoming flat file, then you have to insert a keyfield in both the ItemData1 ,ItemData2 .

For this ,you need to use ItemData1.keyFieldValue and ItemData2.keyFieldValue in your FCC parameters.

Also, need to mention the keyFieldName in both ItemData1 ,ItemData2.(ex:ItemData1.fieldNames).

Hope the below blog would help you.

/people/sukumar.natarajan/blog/2007/06/12/content-conversion-in-sender-file-adapter--2-new-useful-parameters

Regards,

Swetha.