Avatar

Community Advisor

Hi @chez_elam ,

 

Yes you can extend the schema.

Or

You can fetch the xml element value from the 'data' field column. Let's assume the xml element you want to fetch is 'phoneNo'. Use query activity on 'nms:eventHisto' table and in 'Add Additional Data' add a column name 'phoneNo1' and use below syntax to define it:

Substring(data, Charindex(data, '<phoneNo =" '), 10);

 

Thanks,

Jyoti