Push Values to all Rows

Question

Hello,

In an effort to not hard code consistent values within my Alteryx Formula tools, I have created an excel with the input data for my end user that they can review and change if needed in the future. These values need to be applied to all rows in my data set. Which tool should I use to do this, and at what point in the workflow would it best go? Thanks!

alexnajm · Accepted Answer

Append Fields Tool is your friend here! Just make sure to filter out all the junk rows/columns beforehand with a Filter and a Select

jrlindem · Accepted Answer

100% what @alexnajm recommends.  Append Tool is the right solution here instead of many formulas.

If your dataset is big, you're going to get warnings about the number of records for appending.  You can change the warn/error settings on the tool to "Allow All Appends" once you've done your validation and testing: