Condition for datatable based on two columns

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.

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


1 Like

Hi @sushmithaelluru

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

Cheers :upside_down_face:

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

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

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

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