Multi-Row Formula

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

107 T2

116 T3

Thanks,

Natalia

Common Use Cases

Accepted answers

afv2688

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

rowID.yxmd

All comments

afv2688

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

rowID.yxmd

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

AddIdentifier.yxmd

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

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335