XML Parsing - HL7 Data

[JenniferO]

Hello Fellow Healthcare users,

Has anyone had any luck parsing the HL7 data?  

Thanks!

-Jennifer

[cmcclellan]

I don't know anything about HL7 (not a US resident at all), but I grabbed the sample from Wikipedia, saved it as an XML file, dragged that into Alteryx and checked Return Root Element (only because that created more fields ;) )

Basically, it's just an XML file, but what's your specific problem ?

[tonyppham503]

Hi @JenniferO,

Have you had any luck? Someone has reached out to me about tools to parse HL7 data as well. 

[JenniferO]

Hi @tonyppham503,

I'm working through the process now.  I think it is possible to use the XML Parse tool to read through the HL7 data.  It just takes some patience to make sure you're getting each data element you're looking for.  Once I have a little more done, I'll try to share part of my workflow.  

Thanks!

-Jennifer

[tonyppham503]

Sounds great, @JenniferO. Good luck!

Tony

[BhumikaS]

Can you please let me know how we can pass HL7 data in alteryx?

[JenniferO]

Try the XML Parse tool, or try this tool: https://gallery.alteryx.com/#!app/Parse-XML/584b5589f499c704689e363b

[DiganP]

Try this as well. 

[wottel]

Hi @JenniferO,

working through the same HL7 issue but the format we get the data is a pipe delimited text file. i attempted to save as xml and pull into alteryx but got an error that it's not a valid xml format. 

Did your HL7 files come in a different format or did you have to do additional formatting before saving as XML? Appreciate any help. 

[Heidi__dup_127]

Hi Jennifer, thank you for sharing the macro!  Would you be willing to share your workflow used to parse HL7 data?