Apply data to existing column

[Pascal_R]

Hi Alteryx Community,

Do you have an simple we to add below "sales weeks used" to the blank Materials?

The sales weeks used is the same for all items, simply changing every week for all. As some items had no sales it shows of course blank, however I need to have this date on each row...

Any Idea how to add it for all entries?

[Emil_Kos · Accepted solution]

Hi @Pascal_R,

Multi-row formula should help you:

The output:

[atcodedog05 · Accepted solution]

Hi @Pascal_R 

Since its same week for all you can do something like this.

Workflow:

1. Using summarize i am taking max of sales weeks used. Null is always min

2. Append the sales week to all rows using append tool.

Hope this helps 🙂

[Emil_Kos]

Hi @atcodedog05,

If we have one value that is definitely an easier solution 🙂