Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

value extraction

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="6...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago
    what is the error in dax ExtractValue[biblio_metadata.metadata],'datafield[@tag="650"]/subfield[@code="a"]'
     
  • v-xiaosun-msft's avatar
    v-xiaosun-msft
    3 years ago

    Hi Anonymous ,

     

    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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago
what is the error in dax ExtractValue[biblio_metadata.metadata],'datafield[@tag="650"]/subfield[@code="a"]'
 
v-xiaosun-msft's avatar
v-xiaosun-msft
Community Support
3 years ago

Hi Anonymous ,

 

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.