Standard deviation on a row of data ?

Question

Hi

I am new to Alteryx, i have looked at other examples and googled but can not seem to work this out.

I have a table of data (below) with rows of data that I want to to find the Standard Deviation for, for each row.

I am sure this should be a one node fix but I can not seem to find the way.

If anyone has a suggestion I would be grateful

Mark

DataNath · Accepted Answer

Hey @mgirdwood, if you Transpose your data to start, selecting all fields other than your numeric ones you want to find the StDev of as your Key Columns:

You can then use a Summarize tool to go Add > Numeric > Standard Deviation:

Finally, you just need to Join it back on based upon the row 'identifier' i.e. [Type] here: