Forum Discussion
Get Latest Entry
Hey everyone, I have a new problem to solve. My data looks like this: Serialnumber LastModified ProductID 134567 1. 2. 2020 THXY22 1869999 1. 2. 2020 THXY22 347584 1. 2. 2...
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 , 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!