IN DU for present validation station and data export i am getting 3 to 4 results for paticular field in simple fields , how to write only 100% first result in excel?

IN DU for present validation station and data export i am getting 3 to 4 results for paticular field in simple fields , how to write only 100% first result in excel ?

here for field name class you can see 3 results, i want to take first highest confidence score as result, in real time i dont use present validation station.
please help me

1 Like

Check this

1 Like

can we do without AI?

Can do. Extraction results can be from any extractor such as Form based, Intelligent Form based

1 Like

Hi @MitheshBolla ,

When using the workflow without Validation Station, What is the Output that you get?

Do you get the Value which has the Highest Confidence or any other value.

By Default, We should be able to get the Value with the Highest Confidence as the Extraction Output.

1 Like

all the values i am getting in excel


But i only need first result

In extraction results i am getting multiple results for each field.

how can i take first result in simple field?

@MitheshBolla There is one way of doing it. Export the results to a data set along with the confidence score of each field. Now read the tables (data table) from the data set and see which fields have confidence score is 1 (When exporting confidence to a data set the score varies varies between 0 and 1)

Please refer to the below link on how to get confidence score into data set

1 Like

@MitheshBolla In export data set activity enable the confidence in the right side properties then you can conf score of each field in the output excel

1 Like

@MitheshBolla ,

The Document Understanding Extraction Result provides us with a Dataset containing One Datatable with one row.

So, The Multiple Options for the Field, such as class in your case, will be in multiple rows. But rest assured, the values with Highest Confidence will be put up in the First row itself.

Therefore you could ignore the Other rows Present.

You can simply access the first row values if you do not want to make any more modifications.

Another Method is to Filter the Datatable, and keep only the First Row as the Output.

or We could manipulate the ExtractionResult to keep only the Highest Confidence values, but again that would be the same as Selecting the First row values

1 Like

how to take first row from data table ?


c# i am getting error

@MitheshBolla ,

If it is a C# implementation, Try the Following :

DataSet.Tables[0].AsEnumerable().Take(1).CopyToDatatable()

If the above doesn’t work, Could you provide us the Error Message ?

1 Like

getting blank output, but not the data in first row of data table.

i used assign
Dt = Dataset[0]

now i want first row from dt

@MitheshBolla That Should have provided us with the First Row Value. But we cannot use Message Box to Check the Output values for the Type System.Data.Datatable.

Could you make another Check like below using Message Box :

DataSet.Tables.Count

Just want to Check the number of Datatables in Dataset.

can i assign it to a variable?

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.