Handle unstructured pdf documents

I will work on several pdf file as an inputs, pdf file are unstructured, and i want to catch the total price from each pdf, note that pdf would come in arabic and english and the price unit would be in riyal or us dollars

so how can we do that automatically?

Developer Tools

Input

Computer Vision

Accepted answers

All comments

OTrieger

@Arwa_Albutainy2712
I guess this is one of the biggest challenges that companies have.

If you do not know where the data will be in the document then go with a Python reader script and the try create mapping based on keywords, and filter out these lines.

However honestly, PDFs or scanned docs does not have a perfect solution, you will need to figure it out as per the data that you have.

Arwa_Albutainy2712

Do you mean python tool?

Arwa_Albutainy2712

And what do you mean by mapping?

OTrieger

@Arwa_Albutainy2712

Yes, using Python tool. Python tool enabling you writing python codes in Alteryx, so potentially whatever you can do with Python you should use in Alteryx.

Arwa_Albutainy2712

What do you mean by mapping?

OTrieger

Creating flags that indicating the text, so you will know which text is needed and which is not.

Such as if it is Grand Total then 1 if Date then 2 etc.

Arwa_Albutainy2712

Which tool do you recommend to do the mapping?

OTrieger

@Arwa_Albutainy2712

I normally using Formula tool, with IF statements, however in your case it is depending on the data itself, you might need to use the Multi Row Formula tool for the IF statement as you might have the text a few rows above the needed text.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703