Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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