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

Extracting individual fields from XML

Rishabh_Awasthi
Active Participant
0 Likes
592

The data stored in MS SQL database column is an entire XML structure.

How to extract the individual fields of the xml from the column??

Regards,

Rishabh

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Likes

Hi,

use extract_from_xml function which is under Conversion functions category  ,this function  will appear only when you select new function call in schema out

Answers (1)

Answers (1)

Rishabh_Awasthi
Active Participant
0 Likes

Thanks Michael