Last Occurrence Type question

Hi there,

I am looking to get the latest product code based on two identifiers, one is called BVFSKU and the other is Vintage:

Module one is called Latest FERT - module to pull the data in to and based on the BVFSKU list

Module two is called Masterdata - module containing all of the data needed and based on a list called masterdata.

So what I would like to do is lookup the BVFSKU in the Masterdata module and find the product codes that match this criteria but then also return the latest product code. The masterdata list is a numbered list so that could provide the latest entry, but we use a display field so we can't see this number

Screenshot 2020-08-17 at 16.45.25.png

Screenshot 2020-08-17 at 16.47.32.png

Hoping someone can help

Accepted answers

andre.lie

pknight@cyt-uk.com

I am not that clear with the screenshot. Is the BVFSKU list in the Latest FERT module is actually the combination of Vintage and BVFSku in the Masterdata module?

I think you can use RANK function to rank each occurrence in Masterdata module and then compare it with the total count for each BVFSKU. The latest product code is that with Rank is equal to Total Count.

Regards,

Andre

All comments

andre.lie

pknight@cyt-uk.com

I am not that clear with the screenshot. Is the BVFSKU list in the Latest FERT module is actually the combination of Vintage and BVFSku in the Masterdata module?

Regards,

Andre

pknight@cyt-uk.com

Hi Andre,

BVFSKU and Vintage are both properties within the Masterdata module. I will certainly take a look at the RANK function and see what it brings back.

Thank you

Phill

pknight@cyt-uk.com

Hi @andre.lie

The RANK solution worked perfectly so thank you for your help

Phill

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…