Has anyone had experience with extracting data from a field that contain XML data? I've attached an example workbook that I want to extract some data from the [Detail] field. I'm hoping it is possible to just display just the <name> and <status> nodes only.
You have multiple name and status combinations in the one row.
It's not going to be possible to use Tableau to explode this out into multiple rows.
You'll need to pre-process it through an ETL tool, a script/program or Excel (Excel does read and translate XML).