Skip to Content

Fcc: need help

Hi folks,

I have a structure.. like this

9000 15102008 16

51080010 39367.16 C BKGBS

51080155 369011.44 C BKGNS

25250090 24835.01 D CACIT

25250140 99992.95 C CADEU

25250050 155344 D CAHSB

14060010 35360913.6 D CCTLB

14060020 18865081.75 D CCTLN

52030290 0.1 D ERRPL

here in header i have 3 fields and line items i have 4 fields ..

is there any option like by no of fileds can i determine whethere it is header or line item.

and the values of header i have to make use in all the line items in the receiver side.

plz suggest me

Regards

Viajy

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2008 at 08:10 AM

    > here in header i have 3 fields and line items i have 4 fields ..

    > is there any option like by no of fileds can i determine whethere it is header or line item.

    Hi Vijay,

    In my opinion there is no suca a way to determine header or line item based on number of fields. You can ask at legacy side to provide some key field in the incoming file and then based on key field you can determin header or line item.

    > and the values of header i have to make use in all the line items in the receiver side.

    To make use of header line for each line item, you can use the standard function UseOneAsMany in your mapping.

    Regards,

    Sarvesh

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 18, 2008 at 07:52 AM

    Hi,

    Can you post the target message structure as well?

    - Gujjeti.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2008 at 07:53 AM

    hi,

    At the most cases header occurs only once. and line items wil be of 1 or 0 to unbounded or 1 to unbounded and din get ur 2nd part well

    Add a comment
    10|10000 characters needed characters exceeded

    • HI

      the target structure is like this

      9000,15102008,51080010,39367.16,C,BKGBS

      9000,15102008,51080155,369011.44,C,BKGNS

      And header will occur once with 3 fields, and remaining all will be line items.

      but i don't have nay keyfield value for header and lien item in fcc i am getting error give keyfiledvalue

      Recordset Structure :Header,1,Row,*

      key field name and values i don't have with out this it throws error

      I got header to all the line items this by using copypervalue

      and splitbyvalue

      now how can i identify header and line item with out keyfield value

      Regards

      Vijay

      Edited by: vijay Kumar on Dec 18, 2008 9:10 AM

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.