We have a Billing Provider Address and Treating Provider address that we are extracting using AI Center Document Manager and Machine Learning Extractor
In the Taxonomy both are set up as Type: Text > Multi-Value: Yes
In Document Manager both are set up as Content Type: String > Multi-Value: Yes
However, when they are exported the fields are different in the spreadsheet.
Our preference would be for the treating Dentist address to match the Billing Address for ease of splitting the fields to key into an application. I’m just not sure why they are coming out different. I don’t think they need to be Multi-Value, it is what was selected originally. I don’t want to change it until I know I don’t need to make any more changes because the process takes so long.
I have tried to set the fields to address in the taxonomy which is supposed to export “formatted” or split but it is NOT consistent/reliable.
Any thoughts or suggestions are appreciated!!
Hello @macaskillh,
How are these addresses in the document? It’s not just the formatting; even the information looks different. For example, Essex Drive, Suite 1000 is not present in the provider address. Even a slight change creates a problem in address comparison. For this, consider using APIs such as Google Maps Platform, Smarty, Loqate, libpostal, or Melissa.
Thanks,
Karthik
These are on an ADA Dental Clam Form. They are not always the same. Treating is the Provider location, the Billing is who/where the bill is sent.
I’m not looking to compare them. I’m wondering if anyone knows why the export is coming out different between the two. Since this post I have found we do NOT have to capture the Treating Provider’s address, however I’m still curious why they are coming out different if the configuration is the same.
@macaskillh
You query is slightly unclear.
The values are in multiple rows (for a field) or value in different columns? what is the issues or it’s something else.
I did not fully understand the question, but I would say post processing can be done after the extraction to combine the fields.
Also, how is data showing in the datatable/dataset variable before writing it to the spreadsheet?
Hello @macaskillh
Even though you have set Multi-Value: Yes for both the attributes.
If the Text for Billing Address is multiple lines, you output will be shown in multiple rows.
And the text for dentist address is in one same line, it will not split into multiple rows- it will give just in line.
As @Rohit_More said, one you have extracted, check for delimiter ( in your case it can be “,”) and perform matching or other operation (contains keywords for each address) for validation.
Hope it helps!
