Write the validated extraction result to excel after 'Wait for Validation Task and Resume' activity

[Nafissa_Al_Abida]

I tried to write the validated extraction result in Excel, but when I tried to use the ‘Export Extraction Result’ activity, the variable type wasn’t matched. What activity am I supposed to use to get the validated extraction result and write it in Excel?

[Yoichi]

HI,

First, according to the foloowing official document, UiPath.DocumentUnderstanding activities package and UiPath.IntteligentOCR activities package should not be used together.

Activities - About the Document Understanding activity package

So, we cannot use ExportExtractionResult activity for output from activities in DocumentUnderstanding activites pack.
Can you try to get data using property and/or method from IDocumentData class instance.

The following document will also help you.

Activities - Document data

Regards,

[Nafissa_Al_Abida]

Thanks for the answer sir

When I look at the activities of the UiPath.DocumentUnderstanding package, I think there is no activity that can be used to get the validated extraction result

I am a beginner, can you please elaborate on how to use the property and/or method from the IDocumentData class instance to get data?

Thanks

[Akash_Javalekar1 (Akash Javalekar)]

Hi @Nafissa_Al_Abida
You can directly write the data we in text file please find below screenshot and if you want to write into excel then you can convert to data table using generate datatable activity

[Yoichi]

Hi,

We can get each data like ValidationExtractionData.Data.[FileldName].Value

Regards,

[Nafissa_Al_Abida]

Thanks for all the answers, I finally can solve the problem. I use the ‘Generate Data Table From Text’ activity to write the validated extraction result in Excel

[Yoichi]

HI,

FYI, it seems we may be able to get datatable directly.
Can you try the following expression?

varDataSet = ValidatedExtractionResult.Properties.ExtractionResult.AsDataSet(False)

Then

varDataTable = varDataSet(0)  

etc.

[Nafissa_Al_Abida]

Sorry, I have not yet tried this because I am a little confused.

So I need to store ValidatedExtractionResult.Properties.ExtractionResult.AsDataSet(False) as a variable named varDataSet?

Thanks

[Akash_Javalekar1 (Akash Javalekar)]

Yes this will give results in dataset and later in write range you can pass dataset.tables(0) as datatable

[Nafissa_Al_Abida]

If I have multiple documents when validating, do I need to add looping when writing the validated extraction results to Excel?

[Yoichi]

Hi,

Can you try as the following image?

Regards,

[Akash_Javalekar1 (Akash Javalekar)]

It depends if you want in single excel to write if columns are fixed you can use merge data table then outside of for each you can take write range workbook in my case there is only one document type so i have used merge datatable for each document