Use Multi Row Formula to Find Current Location of Shipment

Hi,

I'm trying to find the current location of a Shipment. I used the transpose tool to get my data into rows and now I'm trying to use the multirow formula to find the Plant where the shipment currently is. However, I'm not sure if this is the best approach.

Input (after transpose):

Desired Output:

This is what the original source looked before transposing for your reference:

Developer

Accepted answers

All comments

Kenda

Hey @andreahq

I think I've accomplished what you're looking for with a couple Sample tools. First off, great job thinking of transposing it. I would've done the same thing!

So it look like you're wanting to keep the second to last record for each RecordID?

If this is the case, first use a filter to get rid of any rows where the Value field is empty. From there, use one Sample tool to group by RecordID then keep only the last 2 rows. Finally, use another Sample tool to again group by RecordID but this time only keep the first row.

First Sample toolSecond Sample toolWorkflow

echuong1

You can assign the max node number to each set of values. From there, you can compare the node number (parsed from the description) to the max number. If they are equal, they will be filtered out of T. The remainder will come out of F.

New Workflow5.yxmd

andreahq

Hi Kenda,

Thanks for your response. I actually want to keep the record based on the "Max Node" value. For example for the Record ID 1, I want the 3rd item, but for the record ID 2, I wanted the 4th item.

Thank you,

andreahq

Hi echuong,

I think this is what I'm looking for but when I run it in my workflow I get all zeros. Not sure what I'm doing wrong

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703