FCC key field value error

[former_member652732]

Hi Experts,

I have a input structure like,

Record

- <Infotype1>

- <ITEM>

- <Infotype2>

- <ITEM>

- <Infotype3>

- <ITEM>

- <Infotype4>

- <Field1>

- <field2>

- <field3>

- <Infotype5>

- <Field1>

- <field2>

- <field3>

i am using sturctured FCC for this,

But the problem is with KeyFieldValue.For Infotype 4 and infotype5 i have a keyfield as A,but for Infotype1 2and 3 i dont have keyfield as it is a one whole row as a item.

is there any way to ignore keyfield in sturtctured FCC,or is there any other way to do.

note: this is a | seperated sturcture(not fixed length)

Thanks in advance,

Monika

Edited by: mona17 on Jul 22, 2009 12:54 PM

[Former Member]

Hi,

Could you please detail the flat file ?

Because if you work on Infotype (HR data) that means in each line you have to know which infotype it is.

Like :

Infotype_00 | my data --> 1st employee

Infotype_01 | my data

Infotype_01 | my data

Infotype_105 | item_1 | my data

Infotype_105 | item_2 | my data

Infotype_105 | item_1 | my data

etc...

Infotype_00 | my data --> 2nd employee

Infotype_01 | my data

Infotype_01 | my data

Infotype_105 | item_1 | my data

Infotype_105 | item_2 | my data

Infotype_105 | item_1 | my data

etc...

and for your Data Type, you should have somehting like that:

<USER> --> Created by your recordset for each new infotype_00 (00 is mandatory in HR !)

<Infotype_00> <Field1> ... </Infotype_00>

<Infotype_01> <Field1> ... </Infotype_01>

<Infotype_02> <Field1> ... </Infotype_02>

etc...

<Infotype_105> <Field1> ... </Infotype_105>

etc...

</USER>

Check your flat file !

Regards.

Mickael

[Former Member]

keyfield is required to identify each recordset/node in your structure

Alternate way would be

Read your flat file in simple structure like

Record...1 to unbounded

-

---

> Row.....1

read flat file row by row in field Row, then apply mapping such that it identifies which infotype it belongs to and accordingly generate target structure

[former_member652732]

I cannot make it infotype 4 and 5 to single row coz it is having some field level mapping..

[Former Member]

Monika,

I dont think you can convert your file into xml without key field in your case.

Regards,

---Satish

[former_member652732]

is there any way i can ignore fieldseperator????

[Former Member]

Monika,

You are having an issue with the key field, not with the field separator. These two are entirely different monika.

Regards,

---Satish

[former_member652732]

i iknow..i thought of changing my data type..

as:

key|ITEM

actually in ITEM also i have value like (A|B|C|),

i m taking whole records in a single item(i need like this only)

but the prb is if i take A as a key field and rest in one item...

sender fcc is throwing ..as it is taking A|B|, and error is like more sturcture is coming in input file.

an i m nt able to handle this..