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

Highlighted
6 - Meteoroid

Hi,

 

I have 2 sheets:

Sheet A:

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

 

Sheet B: Average(Month)

NameFebJan
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)
Apple24
Apple Total105
Beta46
Beta Total117

 

Thank you!!

Highlighted
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.

AbhilashR_0-1589091622205.png

 

 

Labels