topic Re: Adding Identifier in Alteryx Designer Desktop Discussions

Adding Identifier

dunkindonut7777 — Mon, 04 Sep 2023 08:40:29 GMT

Hi I want to know if how can I add a ascending order identifier of each line just like the fill in series function in excel. I want to add a number every location. See sample below:

Code	Location	Identifier (Expected Output)
11111	California	California1
11111	California	California2
22222	Ohio	Ohio1
22222	Ohio	Ohio2
44444	Texas	Texas1
44444	Texas	Texas2

How can I add another identifier column considering there are thousands of lines reflected in the data? Thank you so much for the helo

Re: Adding Identifier

Raj — Mon, 04 Sep 2023 08:51:39 GMT

Use multifield formula tool to achieve this output

Re: Adding Identifier

Raj — Mon, 04 Sep 2023 08:56:18 GMT

PFA

Re: Adding Identifier

FinnCharlton — Mon, 04 Sep 2023 09:01:16 GMT

Hi @dunkindonut7777 , here's how you accomplish this:

We start by creating a unique identifier for each duplicate location. We can do this with the multi-row formula tool grouped by location - doing this we ensure we start counting again for each new location. We can then use a formula tool to create the Identifier column.

Re: Adding Identifier

binu_acs — Mon, 04 Sep 2023 09:06:12 GMT

@dunkindonut7777 Another method using Tile tool