Skip to Content
avatar image
Former Member

Problem in key field name in FCC

hi,

I am using FCC on the sender side.

Source file is

1;;PY;X101;20060630;06;20060630;GBP;Ref.1;Payroll June 2006; (Header)

1;1;40;S2225000;;1050;;;;;;;;;;;;;;;X101003;;;;;;;;;;;;;;;

1;2;240;S2225000;;4563;;;;;;;;;;;;;;;X101004;;;;;;;;;;;;;;;

1;3;31;3100001;;5013;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

1;4;31;3100002;;600;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

2;;PY;X101;20060630;06;20060630;GBP;Ref.2;Payroll June 2006; (Header)

2;1;40;S2225000;;530;;;;;;;;;;;;;;;X101003;;;;;;;;;;;;;;;

2;2;40;S2225000;;2490;;;;;;;;;;;;;;;X101004;;;;;;;;;;;;;;;

2;3;31;3100002;;3020;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

The first field in the header is the key field to identify the header, which keeps incrementing for evry occurence of the header.

So for the first occurence of the header first field of header will be 1, first field of item will be 1( same as header) and second field of item will be the key field now which will increment with evry occurence of item within the header.So there is no constant value for key field name.

So how do i perform FCC for this type of structure?

Regards,

Loveena

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 24, 2008 at 03:40 PM

    Header.fieldNames= F1,F2 upto last field

    Header.fieldSeparator = ;

    Header.endSeparator = 'nl'.

    I dont think Key field name and Value is required, you can go by simple FCC.

    BR,

    Alok

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 24, 2008 at 03:57 PM

    hi ,

    My question is then how do i identify the header and item record ?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Loveena,

      The distinction between header and line item can be handled in mapping. in my current object i did the similar thing. for single header i am getting multiple line items.

      You can make use of Format by Example node function and achieve that. You can trigger single target msg for one header and multiple line items.

      Please explain your scenario a bit. source MT and target MT, their occurence and what is business scenario.

      BR,

      Alok