Unsure how to proceed to compute a variance

Question

Hi all!

The backstory of my workflow is that I have two different Excel files that I am ultimately trying to join and derive a variance for each row in the file.

I added a 'TAG 1' in both files, which will ultimately compute a unique identifier for each row in the file; and will match across. I cleaned up both files to ultimately show only the TAG 1 as well as the PQ1-PQ9 values. I want to prompt Alteryx to compute a variance for each row based on the unique identifier. How can I go about this?

Currently, the files have not been joined together as the 'Join' tool is not triggering anything to connect.

Thank you so much in advance!

apathetichell · Answer

Did you want a variance vs mean PQ1-PQ9 by tag? I wasn't quite sure what you wanted - and obviously in the sample data the variance will end up being 0 since the data is all the same.

Qiu · Answer

@kimberlyka

I think I have created the Tag for comparation, but dont know how to compute a variance as your mentioned.

20210525-kimberlyka.yxmd

kimberlyka · Answer

Hello!

Two sample files are attached and Tag 1 is set within a formula tool: [CPAS ID] + [Business Division] + [Sub Segment 1] + [Sub Segment 2]

MOD - PPNR Masterfile Template - Alteryx.xlsx

PPNR Masterfile - MOD - Alteryx Mock.xlsx