Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Return difference between sales data of consecutive months

sraddhadurga
5 - Atom

Hi All,

I need to calculate the difference between sales data of consecutive months. I have attached the input files and output file. Kindly help me with a workflow to achieve the same.

Input files-1) Data_Jan

                 2) Data_Feb

Output File- output

 

5 REPLIES 5
jamielaird
14 - Magnetar

Hi @sraddhadurga ,

 

Something like this?

 

-----

If I've answered your question please consider marking this solution as accepted. Thank you!

Thableaus
17 - Castor
17 - Castor

Hi @sraddhadurga 

 

Here's a dynamic solution for your case. The flow is a bit large, but it basically fits if you have any number of months and files to add.

 

The only I thing I didn't do is to put columns in proper order in an automated way. But that's possible too, it would just make the flow larger.

To make it work, you need to change the input tool to put your Data_Month file. Don't forget to change the "Month" part to an asterisk (*), this will be your wildcard to union files.

 

Please let me know if you have any doubts.

 

Cheers,

ankit_mandal
6 - Meteoroid

Hi @sraddhadurga ,

Please try this.

 

 

Thanks, 

Ankit.

sraddhadurga
5 - Atom

Thank You!

sraddhadurga
5 - Atom

Thank You so much!

Labels