Unanswered

Extract information from documents with varying lines of data

(0) Share

Report

Posted on by pbiadmin123

Hi all,

I'm using the AI builder to create a model which extracts data from our chemical batch receipts. The receipts are in a standardized format. The second page of the receipt contains the 'Components' list. This 'Components' list can vary from 4 products up to 11. How can I create one model to capture the component code and quantity data regardless if there are 4 line items or 11. Below are two examples of how they can vary, one with 8 line items and another with 4

Categories:

AI Builder

I have the same question (0)

All responses (2)

Answers (0)

Antrod Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @pbiadmin123 ,

If you create a table to capture this data, it should be able to adapt to any number of lines. Make sure to give the model documents with various number of lines.

Was this reply helpful? Yes No
pbiadmin123 6 on at

Like (0)

Report
Copy link

Link copied!

So i've done this and it's working as expected - is there a way to reference one singular 'cell' in this table to use as an input for a 'create JSON' action?

Was this reply helpful? Yes No