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

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

 

3 REPLIES 3
IraWatt
17 - Castor
17 - Castor

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?

 

pramodgupp
5 - Atom

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

IraWatt
17 - Castor
17 - Castor

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?

 

Labels