Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
We’re experiencing technical issues with our vendor that are affecting license activations for Designer Desktop. We don’t yet have an estimated resolution time. We apologize for the inconvenience and will share updates as we have them.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to populate 1 field text to all rows?

kitkat
6 - Meteoroid

I'm trying to take the text from say row 1 that contains a name and have this text populated as a new field for every row in the file. 

 

So for example, an input for Row1, field 1 contains a month name.  How would I get this same month generated as a row text for each record?  

2 REPLIES 2
tcroberts
12 - Quasar

You could use a MultiRow Formula Tool configured to create a new field, and to set "Values for Rows that don't Exist" to "Values of closest valid row". Your formula would then just be:

 

[Row-1:Name]

 

 

Since the MultiRow Formula Tool runs row-by-row, as it moves down the dataframe, the previous row will have already been populated with that value, allowing it to continue.

 

Let me know if this helps or you need clarification,

 

Cheers!

kitkat
6 - Meteoroid

thank you! i understood what you were getting at and have it working

Labels
Top Solution Authors