EDI as a Source?

[cap_mike]

Anyone using Alteryx to transform EDI files? Specifically EDI 852 Product Activity Data to SQL Server destination tables?

[MarqueeCrew · Accepted solution]

I worked a project for a client. Made use of parsing tools and RegEx.

[cap_mike]

Thank you for your reply! Can you provide an example solution file or Screenshots that shows how the parse tools were used? Was the source file a TXT or an EDI file type? 

[MarqueeCrew]

I don't have an example (client work), but if you PM me with your email and availability today we can WebEx and explore. 

[dahl19]

Hey All,

I need some help here. I am trying to compare two EDI 834 files out of two source systems.  Is there an easy way to import EDI files into Alteryx?  Thanks in advance,  Dan

[_wlm_horton]

You can import them as text files using the standard Input tool. There is no easy way to transform them into anything useful yet, but it can be done.