AnsweredAssumed Answered

How to capture Unbound XML tag value to one db column

Question asked by varshith.reddy293175 on Mar 24, 2017
Latest reply on Mar 26, 2017 by varshith.reddy293175

I have a requirement to map attribute values from my XML to database which is fairly easy and straight forward, but i have a unbound attribute in my XML profile and i want to map all the values coming in that unbound attribute to one column in my database as comma separated. 

 

My input XML looks like below, I want to map all the values coming in code tag to one column in database as comma separated. In my mind this seems simple but i think i am missing something when i actually map it from XML to db. 

 

db output should look like below where codes column should have values as comma separated. 

Codes

-----------

01,02,03,04,05

 

any help is appreciated. 

 

Thanks

Varshith Reddy

Outcomes