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

[BRRLL99]

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

[rohit782192]

This can be achievabke using Running Total. You will get a set of Output of 1 , 2 ,3 ... for Every Start and End Record.

[binu_acs]

@amitsingh2993 Another option using tile tool