Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Adding data from Input sheet to last row and calc SD

prveenk86kumar
7 - Meteor

 Hi All,New to alteryx trying to solve some problem.

 

I have input file which i get every month and i need to pick only certain data from it and paste it to sample SD file. I have highlighted the same in input file. Can you help me in designing the below

 

1) Fetching the data from Input file every month - only latest data to be added to last row of the SD file.(So next month i will just add the same file as input file)

2) And in SD file - Column - Calculate the SD deviation formula used in excel =IFERROR((B26-AVERAGE(B$2:B26))/STDEVP(B$2:B26),"")- I just want for that particular month

 

Attached the input and SD file, your help is appreciated 

2 REPLIES 2
prveenk86kumar
7 - Meteor

any help would be appreciated 

prveenk86kumar
7 - Meteor

any help with above question

Labels