Autofill a string field

sarithaligonanu

Hi there,

I am fairly new to alteryx. I don't even know how to ask a question 😞 sorry!

Please see my input and the desired output below.

In the input there will be empty values for the ID field (string)?

I have to assign new IDs to these products in the format 'Product.xxx'. But the xxx' part has to increased by 1 each time.

Is there a way alteryx can auto-fill the ID field (string)?

Example input:

ID	Product
Product.001	Apple
Product.002	Orange
Product.003	Mango
	Kiwi
	Banana

Output I am after should look like this:

ID	Product
Product.001	Apple
Product.002	Orange
Product.003	Mango
Product.004	Kiwi
Product.005	Banana

Thanks heaps,

Output

Accepted answers

No problem, you could easily create a new field with the same formula, leaving the existing ID column alone. The logic remains.

All comments

One way is to add a record ID using the recordID tool. Keep in mind that you'll want to use a string here, and specifiy how many digits you want to include (in your example, 3).

Then follow with a formula tool, modifying your existing ID column with the formula

"Product." + [RecordID]

and then you can drop the original recordID field with a select tool. This is a simple way to go about it.

sarithaligonanu

Thanks for the reply.

But I am not allowed to modify the existing ID column as we are using this as unique ID field and used in lots of other calculations and comparisons between weekly reports.

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703