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