Last Occurrence Type question

Options
pknight@cyt-uk.com
pknight@cyt-uk.com Member, ALL USERS, Community Member Posts: 5 Occasional Contributor

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

 

 

Comments

  • pknight@cyt-uk.com
    pknight@cyt-uk.com Member, ALL USERS, Community Member Posts: 5 Occasional Contributor

    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
    pknight@cyt-uk.com Member, ALL USERS, Community Member Posts: 5 Occasional Contributor

    Hi @andre.lie 

     

    The RANK solution worked perfectly so thank you for your help

     

    Phill