Hi All,
how we can provide next numeric value when value in next column repeat.
Input:
Field1 |
Uid |
pass |
Number |
Details |
Uid |
pass |
Number |
Home |
Uid |
pass |
Number |
Details |
output:
Field1 | New Field |
Uid | 1 |
pass | 0 |
Number | 0 |
Details | 0 |
Uid | 2 |
pass | 0 |
Number | 0 |
Home | 0 |
Uid | 3 |
pass | 0 |
Number | 0 |
Details | 0 |
Thanks
This can be achieved with 2 multirow formula tools.
In the first Multi row formula tool use the below expression:
IF [Field1]="Uid"
THEN [Row-1:New Field]+1
ELSE [Row-1:New Field]
ENDIF
Make sure you select the option Create New Field.
In the second Multi row formula tool use the below expression:
IF [Field1]="UID"
THEN [New Field]
ELSE 0
ENDIF
Make sure you select the option Update Existing Field option.
Then run the workflow to get your result.
Many thanks
Shanker V
Use Multi row formula
and create new field with this formula
IF [Field1] = 'Uid' THEN
ToString(ToNumber([Row-1:New Field])+1)
ELSE
'0'
ENDIF
This can be achievabke using Running Total. You will get a set of Output of 1 , 2 ,3 ... for Every Start and End Record.
@amitsingh2993 Another option using tile tool