Different options to import XML

Question

Hello,

New user and looking forward to learning Alteryx.  Looking for suggestions on how to import the attached XML file:

* Capture device names found in rows 5 – 48 such as;* 111801005495
* 111801009217

* Capture user and attributes found in rows 51-130 such as;* Admin superreader=yes
* user1 superreader=yes

I've tried the input data as XML and CSV, however, I'm stuck.  I have outer XML files types to define, so I thought I'd post to see what the community thinks.

Thanks,

-Joe

OT.xml

joesparty · Answer

I've been able to make some progress and looking to get this across the line. Using the option to define as a CSV I've been able to get a RegEx to work. The goal is to extract the Device fields until the first TypeEnd=. I was trying to use the Summarize with a First option, but it didn't work. So the answer should be RecordID 4 - 48, then filter for !IsNull(Devices). dev_OT.yxmd

joesparty · Answer

Yes getting Alteryx to dynamically define the file is the issue.  Does anyone have a preferred regex converter website?

apathetichell · Answer

you can sort out between your two different record types by  setting a filter with REGEX_Match([name],"\d+") - not sure about your member embedded xml field though. Can't get Alteryx to dynamically choose that one.