Adding a new, populated field to existing data - Generate Rows Tool?

[tsnouffer]

I have a set of data that natively has two fields, Customer ID and Number of Visits, with about 2.0M records. It looks a bit like this:

Cust ID	Visits
12345	34
32453	5
23795	21

I'd like to supplement that set with a third field called "Month" and simply add the same value for each record. "Sept" in this case so it would look like this:

Cust ID	Visits	Month
12345	34	Sept
32453	5	Sept

I'm honing in on the Generate New Rows tool, but the syntax for pulling off what I want is eluding me. I'm certainly new to Alteryx, but I think I am close to pulling this one off.

Any suggestions for the "Initialization Expression," "Condition Expression," and "Loop Expression?"

Thanks

Ty

[MarqueeCrew · Accepted solution]

You could simply use a formula tool to create a new field, month. The formula would be: "Sept".

Ok?

[tsnouffer]

Ah, I forgot about that tool. Glad it is that straighforward!

Thanks