Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How can I parse a specific child and not descendants similarly named?

hellyars
13 - Pulsar

How can I parse a specific child and not pick up descendants similarly named?   And, I can't edit the names.

 

In the example below, I want to parse only the first child named "Name" under "Item Group."   The parse tool is picking up all  descendants of "Item Group" named "Name".  So, how can I target the first child or a specific generation?

 

 

<ItemGroup>
    <Name>Product ABC</Name>
    <CategoryList>
        <Category>
            <Name>Something</Name>
		</Category>
	<!-- yada yada yada -->
	</CategoryList>
</ItemGroup>            

Thanks

1 REPLY 1
LordNeilLord
15 - Aurora

Hi,

 

This is a bit hacky but it works on your example:

 

  • I parsed out the the itemgroup using Auto Detect and include the returned the outerXML
  • Then Parsed out the Child "Name" from ItemGroup
  • A third Parse tool to parse Child "Name" on Category_outerXML
  • Finally remove any row where the ItemGroup Name = Category Name

xml.PNG

 

 

Labels