Alphanumeric - latest value

Hi,

Trying to get the latest value based on a date.

The data looks like this :

Everything is brought in currently as the default of string.

What I need to do is to filter out all lines where there are multiple lines of newer dates to get the most recent costs. I can convert numbers to numbers and strip the order_id back to numbers, just don't know how to proceed to get what I need.

For the above, this would mean that records 2,3 and 5 would be returned only.

Any ideas on how to approach this would be great.

Thanks

Workflow

Output

Dynamic Processing

Accepted answers

Yoshiro_Fujimori

@Baz123 ,

One way of doing this.

Workflow

To properly order by date, you need to convert the data type to DateTime.

Output

I hope this matches with your needs.

LatestValue.yxmd

All comments

binu_acs

@Baz123 Add a summarize tool then group by order_id, line_id , and MAX of Date field will give you the desired results

Yoshiro_Fujimori

@Baz123 ,

One way of doing this.

Workflow

To properly order by date, you need to convert the data type to DateTime.

Output

I hope this matches with your needs.

LatestValue.yxmd

Baz123

@binu_acs - thanks, works as suggested. However as the real data set contains more categories of data I need to retain then the solution by @Yoshiro_Fujimori was used.

I'm currently still learning, so when using a Summarize tool I need to still need to figure out when to use it, and if / when / how to merge the data after the tool works back into the original dataset

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703