FCC on Sender CC to convert flat file to complex xml structure

[Former Member]

Hi ,

i need to create a complex xml structure using FCC at the sender communication channel.

the datatype structure is as follows:

Data type Occurrence

DT_SOURCE

SEG_9 1..1

SEG_10 1..1

SEG_20 1..1

SEG_30 0..1

SEG_40 1..2

SEG_50 0..1

SEG_55(loop) 0..1

SEG_55 0..9999

SEG_60-70(loop) 1..1

SEG_60 0..1

SEG_70 0..9999

SEG_90 0..1

Please let me know how this can be acheived.

Regards,

Meenakshi

Edited by: meenakshipradhan on Apr 5, 2010 7:44 PM

[Former Member · Accepted solution]

Hi,

the data type structure is as follows:

Data type Occurrence

DT_SOURCE

SEG_9 1..1

SEG_10 1..1

SEG_20 1..1

SEG_30 0..1

SEG_40 1..2

SEG_50 0..1

SEG_55(loop) 0..1

SEG_55 0..9999

SEG_60-70(loop) 1..1

SEG_60 0..1

SEG_70 0..9999

SEG_90 0..1

Regards,

Meenakshi

[VijayKonam · Accepted solution]

You need to tell the flat file structure first. Also, depending on the file strucuture your datatype could change.

VJ

[Former Member · Accepted solution]

Hi Meenakshi,

Please let us know the Hierarchy of the structure to be created, is it one level only?

Could you please explaing what is the loop meant here?

SEG_55(loop) 0..1
SEG_55 0..9999
SEG_60-70(loop) 1..1

Please specify if there are any delimiters or what is the file format at source.

Or Try reading the whole content of the file then use a XSLT to create the desired structure, i think in XSLT you can easily try out the looping.

Regards,

Srinivas.