Hi all,
I've been trying to update a column, but I've been stuck for a while and could use some advice on how to move forward to fix this.
Sl.no | NAME | TYPE | PRE | OP | REQUIRED Output |
1 | BOTTLE | C1 | C1 | ||
2 | BOTTLE | E1 | E1 | ||
3 | BOTTLE | E2 | E2 | ||
4 | BOTTLE | E2.A1 | E2.A1 | ||
5 | BOTTLE | D1 | D1 | ||
6 | BOTTLE | E1.A1 | E1.A1 | ||
7 | BOTTLE | E1.A2 | E1.A2 | ||
8 | BOTTLE | E | A1 | E4.A1 | |
9 | BOTTLE | E3 | E3 | ||
10 | BOTTLE | C | A1 | C2.A1 | |
11 | BOTTLE | C | A1 | C3.A1 | |
12 | BOTTLE | A | E1.A1.P1 | E1.A1.P1 | |
13 | CAR | C1 | C1 | ||
14 | CAR | C2 | C2 | ||
15 | CAR | E1 | E1 | ||
16 | CAR | E2 | E2 | ||
17 | CAR | C | E2.b1 | E2.b1 | |
18 | CAR | C | E2.D1 | E2.D1 | |
19 | CAR | C | E1.A1 | E1.A1 | |
20 | CAR | D1 | D1 | ||
21 | CAR | A1 | A1 | ||
22 | CAR | E3 | E3 | ||
23 | CAR | A | q1 | A2.Q1 |
For the missing fields, I want to update them by determining the highest value of the same [TYPE] in the same [NAME], incrementing it accordingly, and concatenating it with the values in [PRE].
EX: In row 8 , we find the type is E and the max value is E3 and hence the op column will be filled as "E4. " concatenating with corresponding PRE i.e., E4.A1
In row 10 &11 we see that the type is c and hence when updating it should be c2 and c3 .
Thanks in advance!
Solved! Go to Solution.
Yes, it can be achieved with the help of Multi field Formula tool.
Many thanks
Shanker V
Hi @ShankerV
I don't think the multi-field formula tool can in fact solve this problem, but regardless I don't think your reply is really that helpful - it's incredibly vague and doesn't really answer the question.
Thanks Finn !
The workflow gave the desired result . Appreciate you providing the workflow so quickly !