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!
Solved! Go to Solution.
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.
Many, thanks for the quick response, let me give a try and let you know on it.
can you please let me know what to choose over here? and the concept of choosing them?
When I apply the requirement to limit the maximum sixe to 1, the other results trickle in as complements.
Nevertheless, I would need all of the distinct information about the audiances sorted in ascending order, and I would need to receive the results as a subset with the most recent date as the result.
Ex: I owe five vehicles each of which I purchased on a separate date. However, the query should return the most current vehicle I purchased in response to all the occurrences of the query in the database.