Required help for Identifying diff. items in file content conversion.

[former_member644654]

Hi All,

I've to use a file content conversion parameters for a .txt file in which there are two objects. One is a header and the other is a item detail.

How do we get or mark the difference between both so that XI recognizes the particular line is a Header and the other is a Item detail

Thanks in Advance.

Regards,

Sree.

[Former Member · Accepted solution]

using the key field

regards

kummari

[Former Member]

Hi

Make use of a field which is common to header and item line which will always hold different values for header and item. Or otherwise if possible, add an extra field in the header and item lines, say 'Key' and use it in the 'Key Field Name' parameter in the adapter configuration. See this for details - [File Content Conversion for Complex Structures|http://www.riyaz.net/blog/index.php/2008/02/20/xipi-file-content-conversion-for-complex-structures/].

Regards,

Riyaz

[former_member194786]

Hi Sreedhar,

You can use this blog by Shabarish for your scenario. It clearly explains the funda for key fields:

Regards,

Sanjeev.

[Former Member]

Hi Sree,

We need to structure the file according to our requirement say you have header and line item in first line then in your mapping logic you have to group the line item data and header data to form a single document.

Thanks

Sudharshan