Help us build a better product, earn the PaxPro Advocate badge: Six short questions, one cool badge. |
Visit the official Paxata Documentation portal for all of your doc needs.
How do I implement Partition-Rank-Filter based on Rank operation in Paxata?

I have a sales data that gives latest aggregated sales every month.
When it deposits data for month of May, it also has latest details for month of Jan, Feb, Mar and Apr too.
The idea is to select the value specified in the latest drop.
So, I want to partition by product-code, rank based on drop-time and then get the latest one.
How do I do this Operation in Paxata?
When it deposits data for month of May, it also has latest details for month of Jan, Feb, Mar and Apr too.
The idea is to select the value specified in the latest drop.
So, I want to partition by product-code, rank based on drop-time and then get the latest one.
How do I do this Operation in Paxata?
0
Answers