value extraction

[SALTA2023]

Hello, I need to extract a value from the metadata table in xml format.
Could you tell me please what is the error in this code? Thank you
 ExtractValue(biblio_metadata.metadata,'//datafield[@tag="650"]/subfield[@code="a"]')

[SALTA2023 · Accepted solution]

what is the error in dax ExtractValue[biblio_metadata.metadata],'datafield[@tag="650"]/subfield[@code="a"]'

[SALTA2023 · Accepted solution]

what is the error in dax ExtractValue[biblio_metadata.metadata],'datafield[@tag="650"]/subfield[@code="a"]'

[v-xiaosun-msft · Accepted solution]

Hi @SALTA2023 ,

If your data or table contains an XML column or LOB data, you must use the DATAFORMAT=XML clause on the EXPORT DATA or EXPORT TABLE command.

You can reference the following documents which may be helpful to you.

Exporting data or tables in XML format - IBM Documentation

sqlpowered.com

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.