Apply data to existing column

Question

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 Answer

Hi @Pascal_R,

Multi-row formula should help you:

The output:

atcodedog05 · Accepted Answer

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 🙂