Forum Discussion
Get Latest Entry
Anonymous , I would prefer to create these two columns and old is that can be deleted
Key = right([Serialnumber], len([Serialnumber])-5)
new column =
if([LastModified]= maxx(filter(table , [Key] = earlier([Key]) && [ProductID] = earlier([ProductID])),[LastModified]) ,"Latest","Old")See if this works for you
Anonymous , Logic to identify, what relaced what is still not clear to me. Can you explain with an example
There are options, but they might not work for you
https://www.youtube.com/watch?v=rqDdnNxSgHQ
Hey amitchandak, I'm sorry, my question could have been formulated clearer.
I have the above table. The product with the ID THXY24 has two rows with serialnumbers starting with 1xxxxx. One of them was last modified on 4. 2. 2020 (the old one) and one was last modified on 7. 6. 2020 (the new one). In this case whatever part is identified by the serialnumber 1xxxxx was replaced on 7. 6. 2020.
I now want to get rid of the row corresponding to the product ID THXY24 with the serialnumber 1xxxxx which was last modified on 4. 2. 2020, as it is currently not in use anymore.
Similarly the product with the ID THXY26 has two rows with serialnumbers starting with 18xxxxx. One of them was last modified on 10. 2. 2020 (the old one) and one was last modified on 4. 3. 2020 (the new one). In this case whatever part is identified by the serialnumber 18xxxxx was replaced on 4. 3. 2020. I want to get rid of the row corresponding to the product ID THXY26 with the serialnumber 18xxxxx which was last modified on 10. 2. 2020 as it is no longer relevant.
My problem is that I can't figure out how to filter out the older, irrelevant rows to delete them afterwards.
I hope this made my question clearer.Anonymous , I would prefer to create these two columns and old is that can be deleted
Key = right([Serialnumber], len([Serialnumber])-5)
new column =
if([LastModified]= maxx(filter(table , [Key] = earlier([Key]) && [ProductID] = earlier([ProductID])),[LastModified]) ,"Latest","Old")See if this works for you
Once again you've helped me a lot. Thank you!