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

Data Analytics

ayadav8
8 - Asteroid

Hey!

 

I have two similar files which contains same monthly columns only separated by 'CM' (current month) & 'PM'(previous month). I want to create two new columns which gives me the difference between the respective months and percentage increase in number. Check the attached screenshot.

 

Example:

[Diff 2017-11-01] = [CM2017-11-01] - [PM2017-11-01]

[% change 2017-11-01] = [Diff 2017-11-01] / [PM2017-11-01]

 

I want the tool to dynamically select the required columns for above formula as every month the dates will change. Moreover the name of the new columns should also change dynamically.

Any help here is appreciated! Thanks.

3 REPLIES 3
MSalvage
11 - Bolide

Hi ayadav8,

 

I have attached a workflow that I think will get you started.

 

Thanks,

Michael

ayadav8
8 - Asteroid

Thank you @MSalvage. Logic works

nehatimothy
5 - Atom

Hey

I also have the same issue and got the solution for the Data Analytics columns.  

Labels
Top Solution Authors