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

File Content Conversion Receiver side

Former Member
0 Likes
428

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
VijayKonam
Active Contributor
0 Likes

Do not use FCC for this. Instead define the XM strucuture as you want in the message mapping and then map the way you want using some UDFs.

VJ

Former Member
0 Likes

Is this possible with UDF's . I wanted a file with wrapper as xml tags and in between csv file ?

can you please give me an UDF example something like this to be achieved !