Alteryx Designer Desktop Discussions

Wafarian · ‎03-15-2023

Hello,

I have a URL that has XML structure and would like to get also the child elements for a particular field.

In the example below, I would like to get the from structure as a field so that I can filter on the values.

<note>

<from>Jani</from>

<heading>Reminder</heading>

<body>Don't forget me this weekend!</body>

</note>

My table structure should be as follows,

note to from heading body

At the moment, I am only getting note field with a message "the cell has trailing spaces and embedded newlines"

thanks,

ShankerV · ‎03-15-2023

One way of doing this.

Input was:

Many thanks

Shanker V

Wafarian · ‎03-15-2023

Hi,

thanks for your input.

It doesn't help me as I would like to split it to columns. I have chosen split to columns but it gives empty values.

thanks

Wafarian · ‎03-15-2023

This is the result that I am expecting

Wafarian · ‎03-15-2023

Hi,

I got it to work by parsing multiple XML parser by checking return outer XML each time.

Deriving XML child elements from URL