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
Solved! Go to 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
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
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