Take a value as a constant and repeat it in a new field

Question

Good dears!

How can I create a new field with a value that I have in the first row of an excel file. That is, I want that value to be repeated in all the rows but in a new field.

In a programming language, you would store that value in a variable and perform an iteration to repeat it.

I attach an image.

Thank you very much and greetings!!

Untitled.jpg

FinnCharlton · Accepted Answer

Hi @GusDC , in Alteryx you would use the Append Fields tool. Here's an example that matches your picture:

Gawa · Accepted Answer

Hi @GusDC

Please refer to the attached workflow.

Trick here is to put 2 Input tool which read the same Excel file, but different configuration; One read only first row while another one read data from 4th row.

Also by using cross tab tool, new column name is set to the value located in F1 in excel file.