Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here

Replacing values from another sheet

6 - Meteoroid



I have 2 sheets:

Sheet A:

NameAverage (Month)Average (Year)
Apple Total35
Beta Total57


Sheet B: Average(Month)

Apple Total103
Beta Total114


I'd like to replace the Average (Month) values for "Total values" in Sheet A with sheet B.

A couple things I'm facing is that:

a) In sheet B, a new month will be added every month but it will always be in column 2.

b) I'd only like to update the values in Sheet A for the Total Values and ignore the others.


My goal is to have to sheet look like this:

NameAverage (Month)Average (Year)
Apple Total105
Beta Total117


Thank you!!

Alteryx Certified Partner
Alteryx Certified Partner

Hi @lil_t, give the attached workflow a try on your larger dataset and let us know if addresses your ask. In my approach, I transpose SheetB to fetch the 2nd column Totals and join it back to Sheet A, after which I use a formula tool to modify the value.