Extract Total

Help Activities
, ,
1

How to get Value for total from Data Table

Example: I have a data table in which the total is already displayed in the end Row how can I retrieve just that Value(53) from data table

Values| Values
Total 53

2

Hello @anmita ,

Use the code below.
dt.Rows(dt.Rows.Count-1)(“TotalColumnName”)

Thanks,
Sanjit

3

Hello @anmita

In your datatable does it have only row? If yes you can use the index of the cell to retrieve the value.

You can use Get Row Item activity and pass the column name.

https://docs.uipath.com/activities/docs/get-row-item

Thanks

4

Thanks @Sanjit_Pal and @Rahul_Unnikrishnan will surely try these

5

@Rahul_Unnikrishnan Yes it does have Rows

6

HI @anmita

You can also try with Lookup datatable activity

https://docs.uipath.com/activities/docs/lookup-data-table

Regards
Sudharsan

7

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