Hi,
I was using pivots for period on period analysis and then provide comments using some basic formulae.
Is it possible to do same using Alteryx, with minimal no manual intervention.
Period 1 Data
Date | Name | Product | Sales in kg | Profit in GBP | Country | IS LLC |
31-Mar-19 | ABC | Steel | 500 | 115 | IN | N |
31-Mar-19 | ABC | Iron | 200 | 220 | US | N |
31-Mar-19 | CAB | Steel | 600 | 204 | UK | Y |
31-Mar-19 | CAB | PoP | 100 | 50 | UK | Y |
Period 2 data
Date | Name | Product | Sales in kg | Profit in GBP | Country | IS LLC |
31-Mar-20 | ABC | Steel | 400 | 220 | IN | N |
31-Mar-20 | ABC | Iron | 300 | 207 | US | N |
31-Mar-20 | CAB | Steel | 500 | 45 | UK | Y |
31-Mar-20 | CAB | PoP | 350 | 190 | UK | Y |
31-Mar-20 | dcb | gold | 200 | 210 | AU | Y |
by combining both tables I used to prepare Pivot and the comments using & functions.
Is LLC | Name | Country | Product | 2019 - Sales | 2020 - Sales | 2019- Profit | 2020 - Profit | Sales Diff | Profit Diff | Comment Sales | Comment profit |
N | ABC | IN | Steel | 500 | 400 | 115 | 220 | -100 | 105 | Movement in Sales for ABC operating in IN is -100 GBP | Movement in Sales for ABC operating in IN is 105 GBP |
N | ABC | US | Iron | 200 | 300 | 220 | 207 | 100 | -13 | Movement in Sales for ABC operating in US is 100 GBP | Movement in Sales for ABC operating in US is -13 GBP |
Y | CAB | UK | PoP | 100 | 350 | 50 | 190 | 250 | 140 | Movement in Sales for CAB operating in UK is 250 GBP | Movement in Sales for CAB operating in UK is 140 GBP |
Y | CAB | UK | Steel | 600 | 500 | 204 | 45 | -100 | -159 | Movement in Sales for CAB operating in UK is -100 GBP | Movement in Sales for CAB operating in UK is -159 GBP |
Y | DCB | AU | Gold | 200 | 210 | 200 | 210 | Movement in Sales for dcb operating in AU is 200 GBP | Movement in Sales for dcb operating in AU is 210 GBP | ||
Grand Total | 1400 | 1750 | 589 | 872 |
Can some one help me in creating same using Alteryx?
Solved! Go to Solution.
Thanks Assaf_m, It was helpful.
I was trying to use combination of V_Wstring,Double and Fixed decimal in Comment section.
For eg.
Sample data:
Country: US (V-Wstring)
Profit: 0.02 bn GBP (Fixed Decimal)
Sales: 100bn (Double)
Expected result: Sales in US is 100bn and profit is 0.02bn GBP.
I have tried this expression: "Sales in" + [Country] + "is" + [Sales] + "bn" + "and" + "Profit is" + [Profit] + "bn GBP".
But I was getting following error: "Parse error at Char: type mismatch in operator +."
Thanks in advance.