Change the table data in extraction results

[gawhade0710 (Durgesh Gawhade)]

Hi,
I am working on a use case where we want to update the extraction results variable for table data so it will show the updated table onto Action Center for human in loop. Mainly I want to perform below to task for table update in extraction results:

1. Remove some rows from table based on condition.
2. Update cell value.

Could you please help how I can achieve this.

[prashant1603765 (Prashant Kumar)]

Hi @gawhade0710

You can remove rows from the extraction results by using a filter activity or by applying a condition to delete rows from the data table. then, update the cell values by looping through each row and modifying the required cells. after these changes, pass the updated data table to action Center so the human in the loop sees the modified table.

If you found helpful, Don’t forget to mark as solution tick .
Happy automation with UiPath

[gawhade0710 (Durgesh Gawhade)]

Hi @prashant1603765
While creating the action center task , we have only input as Extraction Result variable and not datatable. I want to know how I can update the extraction results variable with my updated datatable.

[adi.mehare (Aditya Mehare)]

Check below thread

How do I change values of a table in extraction results?

Hi All, I Have a data table defined in taxonomy. I need to make a look up and add values to the table. However I can’t do it in a data table variable as I need to pass this change into an extractionresult to send to action center. Hence I’m trying to manipulate the extractionresults.results document variable and change the fields and values of it. How do I find which index my table is in and how do I find the index of columns? Thank you!

[prashant1603765 (Prashant Kumar)]

Yes @gawhade0710

Pls check below link,

How do I change values of a table in extraction results?

Hi @sharon.palawandram , I was able to check on the modification to be done by using Json Serialize and Deserialize Methods. Inspecting the Extraction Results Json : First off, our taxonomy would always be fixed, this would also mean that the Table columns defined would also be fixed. Keeping that in mind, we can at the beginning check the extractionResults value by Serializing it to a String, so right after the Data Extraction Scope (I performed it in Extraction Rules Check workflow of DU F…

OR

Create action with custom extraction results

Finally did it! I needed to properly define and initialize ResultsValue arrays before assigning This example works fine (from a previously initialized ExtractionResult variable). Invoke activity is used after Extraction Scope activity to insert “custom” values. [image] I got a little bit confused when documentation indicated list instead of array: [image] https://docs.uipath.com/document-understanding/docs/results-data-point-class Hope it helps!

Happy AUtomation

[gawhade0710 (Durgesh Gawhade)]

Thank you @adi.mehare @prashant1603765
I checked the solution provided in different forum post however with this , we might miss the link between the document and values extracted as we are removing the reference while creating our own json for table data.

Is there any way to keep the relation between extracted value and document , also update/delete the row?