Multi-Row Formula

[nwatzlaf]

Hi there,

I want to assign an identifier to rows after a filter has been applied. Out of the True I want to add the identifier for every line that is part of the same order number..

EX:      Order Number        Identifier

            101                         T1

            101                         T1

            107                         T2

            116                         T3

Thanks,

Natalia

[afv2688 · Accepted solution]

Hello @nwatzlaf,

Apply this formula:

IF [Row-1:Field1]!=[Field1] THEN [Row-1:ID]+1 ELSE [Row-1:ID] ENDIF

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

[RolandSchubert]

Hi @nwatzlaf ,

you can use the Multi-Row Formula tool for that. Sample workflow attached. Sort by Order Number and add 1 to the Identifier (I assume, "T" is used as a prefix for the identifier). Hope this is helpful.

Best,

Roland

[nwatzlaf]

Hi there,

I have a modification to another multi-row tool. I am trying to set up a formula that identifies products as part of a basket as seen below. The number would be the product count in the basket.

Basket A       Apple                 1

Basket A       Banana              2

Basket B       Pear                   1

Basket C       Strawberries      1 

Thanks,

Natalia