How to do FCC for the below requirement

[Former Member]

Hi experts,

My File Strutre is

ABCD:1234,

xyz:5668,

fhgt,6783,

my required structure is

TEST_MT

InputA

InputB

TEST_MT

ABCD

1234

xyz

5668

fhgt

6783

Here My doubt is I am not required RecordSet Name and RecordSet Structure.

Regard's

Preethi.

[ambrish_mishra]

HI Preethi,

Not clear on your file data:

ABCD:1234,

xyz:5668,

fhgt,6783,

Is it separated by comma or colon. In the third record, you have a comma. It may be a typo.

You can do FCC with colon as delimiter. You can use ignoreRecordsetName in FCC and use simple FCC to read the file.

Have a source structure like below

MT_SOURCE

     Record                  1 ...unbounded

          Field1

          Field2

You can ignore the comma with Field2 in mapping.

Ambrish

[Former Member]

Hi Anand,

when you say "my required structure is", are you really talking on your source structure or on your wanted target structure after mapping ?

This is just to be sure, that what you want to do can be done in FCC (only) or simply in Message Mapping.

coz, for the moment, I do not understand why you do not define FCC to have that for your source:

<row><InputA><InputB></row>

<row><InputA><InputB></row>

<row><InputA><InputB></row>

which is the same than:

<row>

     <InputA>

     <InputB>

</row>

<row>

     <InputA>

     <InputB>

</row>

<row>

     <InputA>

     <InputB>

</row>

regards

Mickael