headerline repeating for every record

[Former Member]

HI,

I have receiver structure as

DT_Name

> recordset 0..unbounded

>> fields 0..1

in content conversion, i gave recordset.addHeaderLIne 3 and down below the field names. I am getting o/p but the problem is the header line is repeating for every record.

how to resolve this.. plz share ur ideas.

thanks,

ravi.

[Former Member]

Hi,

I guess you have to apply a little trick here if your HeaderLine values are built with some constant values e.g. Name, age, address etc..

If above assumption is correct then you just duplicate the recordset (right click on recordset & press duplicate subtree). Now in first recordset node map some constant e.g. 1 and in the "fields" map your HeaderLine values.

In the second recordset node, do your other mappings as you did before except headerLine values.

By this way your header values will come only once.

Regards,

Sarvesh

[Former Member]

Hi Sarvesh,

Will the below change work ?

Including one more tag Row (0..unbounded) below recordset and under Row, the fields..

in Content conversion

structure -> Recordset,Row

Recordset.addHeaderLine -> 3

Recordset.headerLine -> fieldnames

Row.fieldSeparator -> ,

Row.endSeparator -> 'nl'

Plz share ideas.

Thanks,

Ravi.

[Former Member]

Hi Ravi,

Please have a look at

http://help.sap.com/saphelp_nw2004s/helpdata/en/ae/d03341771b4c0de10000000a1550b0/frameset.htm

You xml structure should look like the following.

1 nameA = your headerline

0..N nameB = your data

<root>...
   <nameA>
         <value1>value</value1>
         <value2>value</value2>
         <value3>value</value3>
   </nameA>
   <nameB>
         <value4>value</value4>
   </nameB>
...
</root>

Edited by: Christian Vilhelm Henriksen on Feb 16, 2010 9:43 AM