community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

How can I parse a specific child without getting everything else?

Fireball

I am running into a wall.  

 

The field with XML data is `P40AItemGroup`.  The XML to parse is the specific child "Name" under P40AItemGroup.  And, it is set to return outer XML.  

 

Here is the problem.  The sibling field Category List has descendants also named "Name."  So, I get all the generations of  "Name"  in a single output column named "Name."  If the descendant children were placed in a Name2 filed this would be less of a challenge, but they are not.  

 

Help!

  

 

Screen Shot 2018-04-19 at 5.40.26 PM.pngScreen Shot 2018-04-19 at 5.46.39 PM.png

Screen Shot 2018-04-19 at 5.43.22 PM.png

Alteryx Certified Partner

Hi Hellyars,

 

I'm not seeing any type of solution using XML parse only, but since it appears that the category has a standard of a digit followed by a parenthesis, we could use regex for eliminating those lines, do you think that is a option?

 

If yes, please see attached solution.

 

regex solution 2.JPG

 

Fernando Vizcaino

Labels