<![CDATA problems ]]>

[hroderick-thr]

Using Designer 2020.3

I'm trying to parse the xml from Tableau tds and twb files.

The xml tool is ignoring content contained in CDATA (Wikipedia CDATA)

To make matters worse, when trying to parse out the CDATA content using simple tools, the formula tool keeps crashing Designer when using a formula tool with this configuration

I'll like and follow you for a solution before I report to support.

Thanks for looking.

[hroderick-thr]

More info...

The snip above repeatedly crashed Designer. But separating as shown below works

[hroderick-thr]

Here is a working wikipedia link: https://en.wikipedia.org/wiki/CDATA 

[danilang · Accepted solution]

Hi @hroderick-thr 

In order to generate the value in the Data Preview field, Designer takes the value from the field in the first data row and calls the Alteryx Runtime Engine passing in this value and the current formula.  The Engine crunches the data and returns the value to Designer to be displayed.  You seem to have hit on a special case that cases the Runtime Engine to crash while trying to generate the preview.  Splitting the formula in 2 generates 2 intermediate results, both of which are processed with no issue 

Other than the split, I don't think that there'll be a work around for this.  Open a support case.

Dan

[hroderick-thr]

Sadly, that is the solution. Ithe formula tool problem is no big deal. It would never be discovered if the xml tool didn't treat cdata as comments.