Mapping problem

[Former Member]

Hi,

I am configuring a file to Proxy interface.

The source structure is

Header

Line1

Line2

Line1

Line2

The target needs to be

header

Line 1

Line2 to one record.

Any ideas is appreciated. Can I make the line1 and line 2 unbounded in the source structure?

[Former Member]

Can you post sample source input file and output file, so we can understand your requirement.

Thanks

[Former Member]

I am not able to understand what you want to achieve. But regarding making Line 1 and Line 2 in source structure to unbounded, you can edit the data type and make the occurrence of the Line1 and Line2 as unbounded. If its a XSD, download the XSD and edit the occurrence to unbounded.

[Former Member]

source

header

line1

line2

line1

line2

Target

line should have fields from header, line 1 and line 2

so in source structure line1 is unbounded and line 2 is unbounded.

How can I have 2 unbounded data types mapped to one unbounded data type in target.

[justin_santhanam]

Jose,

Could you please give us the exact source and target structure with occurrences, it will be easy for us to suggest.

Thanks for understanding!

raj

[Former Member]

Source file

- <header>

<rectype>1</rectype>

<batchamount>000045300</batchamount>

<batchcount>00033</batchcount>

<bankregistercode>3B</bankregistercode>

<corpcode>208</corpcode>

<batchdescription>ANUAL</batchdescription>

<filler1 />

</header>

- <line1>

<rectype>2</rectype>

<invoiceamount>0000098000</invoiceamount>

<state>LA</state>

<vendorid>Steve</vendorid>

<venodrname />

<filler2 />

</line1>

- <line2>

<rectype>3</rectype>

<distributionaccount>988100</distributionaccount>

<filler3>0</filler3>

<numericstatecode>21</numericstatecode>

<distributionamount>0000008000</distributionamount>

<filler4 />

</line2>

- <line1>

<rectype>2</rectype>

<invoiceamount>0000015000</invoiceamount>

<state>LA</state>

<vendorid>BATROULA</vendorid>

Target is one single line

[Former Member]

Target is one single line

What elements are inside the Line elements in target ? what source data need to map to those elements ?

I believe the line is also 1:unbounded, right ?

Liang

[Former Member]

If you want the source to be in one line you should use concatenate. I fthere are many apperances you migth need to use an UDF.