Fcc: need help

[vijay_kumar133]

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

[Former Member]

> 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

[vijay_kumar133]

Hi

For example if the file containg allway only one header and rest as line items,

then there is any possible to figure out which is header and line items..

Regards

Vijay

[Former Member]

Hi,

If header line will always come at first position then I guess there will be no problem. Just setup FCC and try.

Regards,

Sarvesh

[vijay_kumar133]

Hi

thanks for reply..

But in FCC what the value of key field name and Key filed value.. with out this it is again showing error.

Regards

Vijay

[Former Member]

Hi,

if your file is coming with fixed length, then no need to use the key field. Configure your FCC as mentioned below

Eg.

Recordset Structure Header,1,Item,*

Header.fieldFixedLengths 10,12,1
Header.fieldNames    field1,field2,field3

Item.fieldFixedLengths 10,10,15,8
Item.fieldNames    field1,field2,field3,field4

Regards,

Sarvesh

[vijay_kumar133]

Hi

the file is comming with comma separated.

then is there any other option.

[Former Member]

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

[vijay_kumar133]

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

[former_member181985]

Hi,

Can you post the target message structure as well?

- Gujjeti.