Page tree
Skip to end of metadata
Go to start of metadata
Summary

Imagine a master data table for different materials and in one column a list of attributes is stored, like "green,huge,expensive", and you want to get these attributes as multiple rows. Here are two different methods for doing that.

One option is to convert the string into an XML string and then use the extract_from_xml() function to turn this XML into a nested structure. This method is preferred whenever the amount of attributes has virtually no upper limit.


Another option is to use the word_ext() function where you can define an upper limit, even if it is times bigger than what you can expect realistically, and the dataflow will still be fast.

 

  • No labels