File content conversion without key

[Former Member]

Dear Experts,

I am working on a file scenario. The input file to be picked up has the following structure:

HEADER <some sequence of characters>

0001<some sequence of characters>

0002<some sequence of characters>

0003<some sequence of characters>

'

'

'

'

'

'

FOOTER<some sequence of characters>

I have to use a structured FCC. Hence keys must be used. The key for header line is "HEADER" and the key for footer line is "FOOTER". But there is no key for the inbetween item lines. Can i pick this file without using a key? The structure of the header line, items lines and footer line is completely different from each other. Is there any solution for this?

[Former Member]

Hello,

can you try as follows:

Recordset structure : HEADER,1,ITEMS,*,FOOTER,1

and attributes as:

HEADER.keyFieldValue = HEADER

HEADER.fieldnames....

Leave blank for ITEMS.keyFieldvalue

ITEMS.fieldnames

FOOTER.keyFieldValue = FOOTER.

FOTTER.fieldnames

Regards,

Sreenvias.

[Former Member]

I think you need to do a work around. Read each line as a single record and then build your target using some logic in the mapping.

Regards

Raj

[dharamveer_gaur2]

Hi

Might these thread would help u