Writing a Query for Dates to pull most recent first anfd ignore the rest

Question

Hello Everyone,I'm attempting to create a query for the workflow in which I must use the data of the customers who have purchased vehicles and then focus on a specific group of customers who have recently purchased vehicles.Example: I owe four vehicles for a specific brand, but I only want to see the most current one depending on when they were sold, disregarding the other three.Can someone quickly support me with this?Thanks in Advance!

Sreevarshini-P · Accepted Answer

Hi @umav ,  First pull all the customers in the query and then try using deduplication For further reference you can go through the documentation Dedup Doc

Shubham_Goyal__ · Answer

Hi @umav ,

You can use the 'Split' activity after your Query activity to Limit the records depending on certain criteria (@purchaseDate or @soldDate may be in your case). Here you can select the column from the table and sort it in Descending order and then limit the max size to 1 and you will get the latest car that was sold/bought by that customer.

Link for more info on 'Split' activity.

Br,

Shubham

Sign up

Login with SSO

Login to the community

Login with SSO