How do I add a sequence to my data

Hi Community,

I need to add a sequence to my data, example, I have to ship from multiple locations so I need to advise the purchasing plant of the ship location, their ship too ( DHL / Plant) and the number of the order so they can reference it.

But each order can only be a max of 20 lines due to receiving constraints.

So I need to say PO# is Location + Ship to + Max 20 lines = PO# 1, then start again, to give me Po#2 etc. But at each change in location or ship to start at #1 again. So in the example. I'd expect 15 PO's for BUBAK - DHL, and 2 POs for BUBAK Plant

Attaching sample data, if anyone can explain how to do this please.

TIA,

Karl.

Sample.xlsx

Workflow

Accepted answers

afv2688

Hello @Karl_Spratt ,

I updated the formula now, let me know if the results are good now.

Regards

PO.yxmd

All comments

pedrodrfaria

Hi @Karl_Spratt

I was not 100% what you are trying to do.

I understand that there is a limit of 20, so should we delete the rows that calculate more than 20 times the PO# instance? Or does that mean that it should go from 2 to 3 even though the SIM PO QTY column still says 2?

I added a WF as shown below to see if this is what you are looking for.

How do I add a sequence to my data.yxmd

afv2688

Hello @Karl_Spratt ,

I came up with this solution. The summarize tools gives you to see the amount of PO box for each location

Regards

PO.yxmd

Karl_Spratt

Hi Guys,

I'm not explaining myself well here, What I'd like to see is example for the location BUBAK

PO's Numbers BUBAK-DHL-01, then next 20 lines where the condition is BUBAK-DHL and these 20 lines, codes this PO# as BUBAK-DHL-02, then next 20 lines as BUBAK-DHL-03 so for the condition of BUBAK & DHL we'd get 15 PO ( 14 PO x 20 Lines) and 1 Po 7 Lines) then it moves to BUBAK & Plant, we get BUBAK-Plant-01, and BUBAK-Plant-02 hope this helps

Location	DHL	Plant	Lines
BUBAK	287	37	324
KARDEX-2	21	274	295
KARDEX-3	20	171	191
KARDEX-4	12	15	27
KOLIN-WH	182	42	224
YUSEN	47	5	52
Grand Total	569	544	1113

Sample.xlsx

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703