Condition for datatable based on two columns

sushmithaelluru · February 20, 2020, 6:29am

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

Thanks.

YAZIDI · February 20, 2020, 10:17am

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

Cheers

Tushar_Karkera · February 21, 2020, 6:12am

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

sushmithaelluru · February 23, 2020, 11:05am

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

Tushar_Karkera · February 24, 2020, 5:13am

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

Tushar_Karkera · February 25, 2020, 6:45am

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