Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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
Top Solution Authors