When same value come alteryx provide next numeric value

amitsingh2993

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

ShankerV

Hi @amitsingh2993 

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