Extracting data as per the filters and last updated "data"

Help
1

I have filtered with respect to column “Ban”
now i want to select the row in which has the last “bill month” and then i want to extract the “Actual Balance Amt” of that last bill month.

Consolidated_Finance_Report_Example.xlsx (78.8 KB)

Can anyone help?

Thanks and Regards

2

what this means buddy
Cheers @AryanSingh

3

I’ve attached an example of what should work for you. Due to the dateformat this actually pretty simple, simply the largest number will do to get the last bill month so after filtering you just need to extarct the largest number, i’ve provided one method you can use :slight_smile: Main.xaml (6.8 KB)

1 Like
4

@Palaniyappan

Please check the excel file. In that there is a Column named “Bill month” in that i have to extract the value of “Actual Balance Amt” of the last update month.

5

@Ellboy

Hey Elliot
Thanks… but i have already extracted the max month data.
What i want to extract is this

image

just like this different “Ban” will have different values of updated last “bill month”. So i want to extract “Actual Balance amount”.

Check the picture.
@Ellboy
@Palaniyappan

6

Ah well all you need to do is grab the row index then and you could use that for instance to set the value. What was your method for attaining the max month data? With that we can tell you the best way to extract the balance value at the same time

7

@Ellboy

I used assign to save the value of last month in a variable.

image
image1920×1080 142 KB

8

The lookup datatable activity should fit your purposes. Just use the month data and filterered table to look up the value in the balance column

9

@Ellboy
since i am new to the Uipath, so just getting to know the basics and everything.
So help me with the syntax and command example for it please.

10

image
image1450×574 27.6 KB

Here’s an example but you’ll have to implement it yourself, it’s honestly quite easy so give it a go

11

thanx @Ellboy

Let me try.

12

using add to collection and it is showing “Column” does not belong to table.
@Ellboy
@Palaniyappan

13

Make sure you’re using the correct column name are instead you can use the index