Skip to Content
avatar image
Former Member

File Content Conversion - Multiple KeyField

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jul 10, 2009 at 11:45 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 10, 2009 at 02:37 PM

    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

    Add comment
    10|10000 characters needed characters exceeded