Condition for datatable based on two columns

Help
1

Hi All,

I need to take the column value Parcel ID based on the latest Sales Date column value.

**I am having the two or more for some Parcel ID’s. **

So which condition I need to take to filter out among them and take the latest Parcel ID , click it and move to another page.

image
image936×460 44.1 KB

I have scraped data and put in the excel sheet below!
Data.xlsx (20.3 KB

Thanks.

1 Like
2

Hi @sushmithaelluru

Maybe try sorting by Sales Date and retrive the first Parcel ID.

Cheers :upside_down_face:

3

Hi @sushmithaelluru Check if this might work for you. Sequence1.xaml (12.0 KB)

4

hey @Tushar_Karkera, thanks for that workflow. But based on the latest date for each parcel ID, I need that in the output.

5

Hi @sushmithaelluru Check this solution if its correct.Filtered according to latest date of each parcel Id. Sequence1.xaml (13.6 KB)

6

@sushmithaelluru Did u check my solutions is it working for u???