How to extract and parse value of XML Memo field from XTKWORKFLOW table in Adobe Campaign Classic

Hello @shruti1,

(Sorry for the print screen in French.)

You need to use the 'NodeValue' function.

For example, if you want to extract the value of 'taskCount', which is an XML attribute of xtk:workflow (so its value is stored in the mData of wtkworkflow), you can do it like this:

• Query the workflows you want using a query activity.

• In the same query or in an enrichment, choose to enrich your data.

• Use the function like this: NodeValue('/workflow/@taskCount', data)
  

   

• Result:

Br,