How to Read File Type 837 (X12-837 or ANSI-837)

Goal

Import EDI 837 health care files, also known as X12-837 or ANSI-837 into Datameer.

Learn

At the moment Datameer doesn't have the native instruments to parse EDI 837 files, but you could ingest these them as plain text. You can then work with the data using the functionality available in a workbook.

For example, ingest data the following data mentioned at EDI 837 Health Care Claim:

ISA*00*          *00*          *ZZ*99999999999    *ZZ*888888888888   *111219*1340*^*00501*000001377*0*T*>
GS*HC*99999999999*888888888888*20111219*1340*1377*X*005010X222
ST*837*0001*005010X222
BHT*0019*00*565743*20110523*154959*CH
NM1*41*2*SAMPLE INC*****46*496103
PER*IC*EDI DEPT*EM*FEEDBACK@1EDISOURCE.COM*TE*3305551212
NM1*40*2*PPO BLUE*****46*54771
HL*1**20*1
PRV*BI*PXC*333600000X
NM1*85*2*EDI SPECIALTY SAMPLE*****XX*123456789
N3*1212 DEPOT DRIVE
N4*CHICAGO*IL*606930159
REF*EI*300123456
HL*2*1*22*1

Steps

1. Create new import job or file upload. 
2. Choose file type CSV/TSV. 
3. Set appropriate the appropriate delimiter, for example *.
4. Execute the job and link the data to a new workbook. 

For the example file snippet, the data appears in the workbook as shown in the following screenshot. Then you could use Datameer functions to transform the data set according to your requirements and start analysis.

Refer to the Importing Data section of our documentation for more details on CSV file ingestion (escape characters, custom schema, etc).

Further Proceeding

In case the instruments available in Datameer can't help you to get required results, you can leverage our plug-in SDK and create a custom connection for particular use-case. Our professional services (PS) team might help you with custom function engineering, if required.