Can the XML Parse tool unravel the U.S. Sanctioned Entities list?

Question

I would like to extract the identities/locations of sanctioned entities from the U.S. Sanctioned List Service. OFAC Specially Designated Nationals List - Sanctions List Service This XML document marks sanctioned entities with the tag, and often under it are variations of the name, identified by <"name id="23456">. The list seems to be too dense or too multi-layered for the XML Parse tool to unravel. Has anyone had experience with opening up multi-layered dense XML documents in Alteryx? Thanks.

NeoInfiniTech · Answer

https://community.alteryx.com/discussion/comment/1436295#Comment_1436295

The workflow I am sharing only applies to generated Customize Dataset XML, and it might not meet your needs as it was built for another purpose than name id parsing, however you might be able to achieve the desired result by tweaking the configuration of Dynamic Select and other tools as you need.

Sanctions_Transformation_Starter.yxmd

Newt · Answer

The U.S. Sanctions List is 200 MB.  How do you read it in, to begin filtering?

Thanks.

Newt · Answer

Have you tried your macro on the U.S. Sanctions List?

OFAC Specially Designated Nationals List - Sanctions List Service

When I attach your macro directly to an input tool with that list, it bombs saying "Tool #47: No valid fields were selected."

When I look at that Select tool, it has selected the "Full Path" field.

Can you provide any hints on how to set up your macro to deal with the U.S. Sanctions List?

Thanks very much for any guidance you can share.

David