Showing results for 
Search instead for 
Did you mean: 

Converting XML object to normal varchar in SAP BO universe

0 Kudos

Hi Experts,

I have a table called "Applications" which includes normal other columns with data type varchar but there is one column which is undefined is "applications" and it contains details XML tag: pfx:LPLForm/pfx:TRANSACTIONS/pfx:TRANSACTION[1]/pfx:grossPremium

please guide me how can i get the "Gross Premium" out of this as the requirement is to get the Gross Premium into the report. How can i convert this to normal column that i can use in Webi.

DB used is My SQL and IDT 4.1.

Please suggest.



Active Contributor
0 Kudos

A screenshot of sample data and the expected result will help us understand your question correctly and give you the possible correct answer.

Accepted Solutions (0)

Answers (0)