cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

File Content Conversion Receiver side

Former Member
0 Likes
436

hello friends:

I needed output file as with xml tags at beginning and ending and inbetween csv file

Eg for the desired output

<Main>

<Header>

<H1> headertext1 </H1>

<H2> headertext2 </H2>

</Header>

<BODY>

A,123,445,455, KUM1ABC

B,XX, YY,ZZ,KUM2ABC

B,12a,446,457,KUM3ABC

B,12b,447, 458,KUM4ABC

B,12c,448,459,KUM5ABC.

</BODY>

</Main>

1. I am receiving a table from sap rfc as source and mapped inside XI to a target structure.

COL1 COL2 COL3 COL4 COL5

A 123 445 455 KUM1ABC

B XX YY ZZ KUM2ABC

B 12a 446 457 KUM3ABC

B 12b 447 458 KUM4ABC

B 12c 448 459 KUM5ABC

2,Create Target structure

Target Structue:

Node

Header

H1

H2

Data

C1

C2

C3

C4

C5

3.At Receiver communication channel i used FCC with Body.fieldSeparator as ',' and i am getting the output as below with total csv file .How to get xml tags at beginning and at ending and in between csv file?

Output:

headertext1

headertext2

A,123,445,455, KUM1ABC

B,XX, YY,ZZ,KUM2ABC

B,12a,446,457,KUM3ABC

B,12b,447, 458,KUM4ABC

B,12c,448,459,KUM5ABC

thanks for reading my message! any clues are appreciated

View Entire Topic
Former Member
0 Likes

thanks