Alert: There is a planned Community maintenance outage October 16th from approximately 10 - 11 PM PST. During this time the Alteryx Community will be inaccessible. Thank you for your understanding!
community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

parsing complex XML file

pramodgupp
5 - Atom
‎06-02-2022 05:49 AM

Hi,

 

I have big XML file with below data and need to extract few field values out of file.

Need to extract only records which has pm=1, pmGroup="some value" and from that record need to select few attribbute values.

Hope you have some solution.

 

 

pramodgupp_0-1654174005951.png

 

Labels:
Reply
3 REPLIES 3
IraWatt
17 - Castor
17 - Castor
‎06-02-2022 06:12 AM

Hey @pramodgupp,

I would definitely try the XML parse tool in designer then use a filter:

IraWatt_0-1654175474480.png

If that doesn't there are a few other options. Can you give a sample of the data to look at?

 

Reply
0 Likes
pramodgupp
5 - Atom
‎06-02-2022 06:14 AM

Can you help me with more detailed info, as am new to Alteryx.

Reply
IraWatt
17 - Castor
17 - Castor
‎06-02-2022 06:33 AM

No worries @pramodgupp, if you search for XML in the search in the top right you will be able to drag on the tool from there and look at examples:

IraWatt_0-1654176549270.png

You should be able to drag your XML onto the canvas from the folder its in then go from there. Can you attach a sample from your XML file so that I can show you an example workflow?

 

Reply
Labels