File Content Conversion - Multiple KeyField

[Former Member]

Hi Experts,

I have the following structures with 2 keyfields

<Structure1>

keyfield1 - value 1

keyfield2 - value 1

<Structure2>

keyfield1 - value 1

keyfield2 - value 2

<Structure3>

keyfield1 - value 2

keyfield2 - value 1

<Structure4>

keyfield1 - value 9

keyfield2 - value 1

Pls advise me, is it possible to have multiple keyfield in our FCC?

If so, advise me how to handle this.

Thanks in advance.

Regards

Bala.

[Former Member]

Bala,

The best thing would be if it is a fixed length file then take field1 and field2 as concatened and as one field which would be your key field. Once when you pick up you can take a substring in the mapping for this field and can map. If you are reading a csv then go with the same approach and take a substring after comma.

Regards,

---Satish

[Former Member]

Hi Satish,

Thanks for your suggestion. But my sender side file contains pipe (|) as a field separator.

Regards

Bala.

[Former Member]

Bala,

In your case you should have go with only one key field as shabharish suggested.

Regards,

---Satish

[Former Member]

Hi bala,

Are you handled that FCC in Sender Side or Receiver Side?

In that Structure1, Structure2 etc., did u mean same Node name or Different Name. Plz put the structure elebarate?

Regards

Vijaykumar

[Former Member]

Hi,

Thanks for your response. I am using the Sender side FCC.

Regards

Bala.

[Shabarish_Nair]

you can only provide one keyfieldvalue for a particular record while configuring the FCC.

So use only one keyfield. And your fieldSeparator will be a |