We have executed a certain code in Python, which has to be replicated in alteryx.
The sample data set is given below.
Order Date Sales Sales_diff
| |
| 2020-02-01 | 1.586325e+05 | -3.644159e+05 |
| 2020-03-01 | 2.110517e+06 | 1.951884e+06 |
| 2020-04-01 | 1.050913e+06 | -1.059604e+06 |
| 2020-05-01 | 9.446381e+05 | -1.062749e+05 |
| 2020-06-01 | 1.256447e+06 | 3.118092e+05 |
| 2020-07-01 | 1.222682e+06 | -3.376500e+04 |
| 2020-08-01 | 1.018037e+06 | -2.046455e+05 |
| 2020-09-01 | 3.075804e+06 | 2.057767e+06 |
| 2020-10-01 | 1.133098e+06 | -1.942706e+06 |
| 2020-11-01 | 2.816970e+06 | 1.683872e+0 |
For the same data we are working to transform it into the 2nd picture using shift() function in python to look like this.
sales_diff month_1 month_2 month_3 month_4 month_5 month_6 month_7 month_8 month_9 month_10 month_11 month_12
| -3.644159e+05 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1.951884e+06 | -3.644159e+05 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| -1.059604e+06 | 1.951884e+06 | -3.644159e+05 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| -1.062749e+05 | -1.059604e+06 | 1.951884e+06 | -3.644159e+05 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 3.118092e+05 | -1.062749e+05 | -1.059604e+06 | 1.951884e+06 | -3.644159e+05 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| -3.376500e+04 | 3.118092e+05 | -1.062749e+05 | -1.059604e+06 | 1.951884e+06 | -3.644159e+05 | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| -2.046455e+05 | -3.376500e+04 | 3.118092e+05 | -1.062749e+05 | -1.059604e+06 | 1.951884e+06 | -3.644159e+05 | NaN | NaN | NaN | NaN | NaN | NaN |
| 2.057767e+06 | -2.046455e+05 | -3.376500e+04 | 3.118092e+05 | -1.062749e+05 | -1.059604e+06 | 1.951884e+06 | -3.644159e+05 | NaN | NaN | NaN | NaN | NaN |
| -1.942706e+06 | 2.057767e+06 | -2.046455e+05 | -3.376500e+04 | 3.118092e+05 | -1.062749e+05 | -1.059604e+06 | 1.951884e+06 | -3.644159e+05 | NaN | NaN | NaN | NaN |
| 1.683872e+06 | -1.942706e+06 | 2.057767e+06 | -2.046455e+05 | -3.376500e+04 | 3.118092e+05 | -1.062749e+05 | -1.059604e+06 | 1.951884e+06 | -3.644159e+05 | NaN | NaN | NaN |
| -2.330960e+05 | 1.683872e+06 | -1.942706e+06 | 2.057767e+06 | -2.046455e+05 | -3.376500e+04 | 3.118092e+05 | -1.062749e+05 | -1.059604e+06 | 1.951884e+06 | -3.644159e+05 | NaN | NaN |
| -1.907109e+06 | -2.330960e+05 | 1.683872e+06 | -1.942706e+06 | 2.057767e+06 | -2.046455e+05 | -3.376500e+04 | 3.118092e+05 | -1.062749e+05 | -1.059604e+06 | 1.951884e+06 | -3.644159e+05 | NaN |
| -2.553179e+05 | -1.907109e+06 | -2.330960e+05 | 1.683872e+06 | -1.942706e+06 | 2.057767e+06 | -2.046455e+05 | -3.376500e+04 | 3.118092e+05 | -1.062749e+05 | -1.059604e+06 | 1.951884e+06 | -3.644159e+05 |
| 1.040504e+06 | -2.553179e+05 | -1.907109e+06 | -2.330960e+05 | 1.683872e+06 | -1.942706e+06 | 2.057767e+06 | -2.046455e+05 | -3.376500e+04 | 3.118092e+05 | -1.062749e+05 | -1.059604e+06 | 1.951884e+06 |
| -2.248020e+05 | 1.040504e+06 | -2.553179e+05 | -1.907109e+06 | -2.330960e+05 | 1.683872e+06 | -1.942706e+06 | 2.057767e+06 | -2.046455e+05 | -3.376500e+04 | 3.118092e+05 | -1.062749e+05 | -1.059604e+06 |
| -1.216302e+05 | -2.248020e+05 | 1.040504e+06 | -2.553179e+05 | -1.907109e+06 | -2.330960e+05 | 1.683872e+06 | -1.942706e+06 | 2.057767e+06 | -2.046455e+05 | -3.376500e+04 | 3.118092e+05 | -1.062749e+05 |
| -2.262664e+05 | -1.216302e+05 | -2.248020e+05 | 1.040504e+06 | -2.553179e+05 | -1.907109e+06 | -2.330960e+05 | 1.683872e+06 | -1.942706e+06 | 2.057767e+06 | -2.046455e+05 | -3.376500e+04 | 3.118092e+05 |
| 1.447180e+05 | -2.262664e+05 | -1.216302e+05 | -2.248020e+05 | 1.040504e+06 | -2.553179e+05 | -1.907109e+06 | -2.330960e+05 | 1.683872e+06 | -1.942706e+06 | 2.057767e+06 | -2.046455e+05 | -3.376500e+04 |
Later the transformed dataset should fill in the null values by resetting the index.
sales_diff month_1 month_2 month_3 month_4 month_5 month_6 month_7 month_8 month_9 month_10 month_11 month_12
| -2.553179e+05 | -1.907109e+06 | -2.330960e+05 | 1.683872e+06 | -1.942706e+06 | 2.057767e+06 | -2.046455e+05 | -3.376500e+04 | 3.118092e+05 | -1.062749e+05 | -1.059604e+06 | 1.951884e+06 | -3.644159e+05 |
| 1.040504e+06 | -2.553179e+05 | -1.907109e+06 | -2.330960e+05 | 1.683872e+06 | -1.942706e+06 | 2.057767e+06 | -2.046455e+05 | -3.376500e+04 | 3.118092e+05 | -1.062749e+05 | -1.059604e+06 | 1.951884e+06 |
| -2.248020e+05 | 1.040504e+06 | -2.553179e+05 | -1.907109e+06 | -2.330960e+05 | 1.683872e+06 | -1.942706e+06 | 2.057767e+06 | -2.046455e+05 | -3.376500e+04 | 3.118092e+05 | -1.062749e+05 | -1.059604e+06 |
| -1.216302e+05 | -2.248020e+05 | 1.040504e+06 | -2.553179e+05 | -1.907109e+06 | -2.330960e+05 | 1.683872e+06 | -1.942706e+06 | 2.057767e+06 | -2.046455e+05 | -3.376500e+04 | 3.118092e+05 | -1.062749e+05 |
| -2.262664e+05 | -1.216302e+05 | -2.248020e+05 | 1.040504e+06 | -2.553179e+05 | -1.907109e+06 | -2.330960e+05 | 1.683872e+06 | -1.942706e+06 | 2.057767e+06 | -2.046455e+05 | -3.376500e+04 | 3.118092e+05 |
| 1.447180e+05 | -2.262664e+05 | -1.216302e+05 | -2.248020e+05 | 1.040504e+06 | -2.553179e+05 | -1.907109e+06 | -2.330960e+05 | 1.683872e+06 | -1.942706e+06 | 2.057767e+06 | -2.046455e+05 | -3.376500e+04 |
| 2.942320e+05 | 1.447180e+05 | -2.262664e+05 | -1.216302e+05 | -2.248020e+05 | 1.040504e+06 | -2.553179e+05 | -1.907109e+06 | -2.330960e+05 | 1.683872e+06 | -1.942706e+06 | 2.057767e+06 | -2.046455e+05 |
| 1.008616e+06 | 2.942320e+05 | 1.447180e+05 | -2.262664e+05 | -1.216302e+05 | -2.248020e+05 | 1.040504e+06 | -2.553179e+05 | -1.907109e+06 | -2.330960e+05 | 1.683872e+06 | -1.942706e+06 | 2.057767e+06 |
| -1.208278e+06 | 1.008616e+06 | 2.942320e+05 | 1.447180e+05 | -2.262664e+05 | -1.216302e+05 | -2.248020e+05 | 1.040504e+06 | -2.553179e+05 | -1.907109e+06 | -2.330960e+05 | 1.683872e+06 | -1.942706e+06 |
| 1.614015e+06 | -1.208278e+06 | 1.008616e+06 | 2.942320e+05 | 1.447180e+05 | -2.262664e+05 | -1.216302e+05 | -2.248020e+05 | 1.040504e+06 | -2.553179e+05 | -1.907109e+06 | -2.330960e+05 | 1.683872e+06 |
| 6.890615e+02 | 1.614015e+06 | -1.208278e+06 | 1.008616e+06 | 2.942320e+05 | 1.447180e+05 | -2.262664e+05 | -1.216302e+05 | -2.248020e+05 | 1.040504e+06 | -2.553179e+05 | -1.907109e+06 | -2.330960e+05 |
| -2.085165e+06 | 6.890615e+02 | 1.614015e+06 | -1.208278e+06 | 1.008616e+06 | 2.942320e+05 | 1.447180e+05 | -2.262664e+05 | -1.216302e+05 | -2.248020e+05 | 1.040504e+06 | -2.553179e+05 | -1.907109e+06 |
| 1.784283e+05 | -2.085165e+06 | 6.890615e+02 | 1.614015e+06 | -1.208278e+06 | 1.008616e+06 | 2.942320e+05 | 1.447180e+05 | -2.262664e+05 | -1.216302e+05 | -2.248020e+05 | 1.040504e+06 | -2.553179e+05 |
| 1.089268e+06 | 1.784283e+05 | -2.085165e+06 | 6.890615e+02 | 1.614015e+06 | -1.208278e+06 | 1.008616e+06 | 2.942320e+05 | 1.447180e+05 | -2.262664e+05 | -1.216302e+05 | -2.248020e+05 | 1.040504e+06 |
| -4.637695e+05 | 1.089268e+06 | 1.784283e+05 | -2.085165e+06 | 6.890615e+02 | 1.614015e+06 | -1.208278e+06 | 1.008616e+06 | 2.942320e+05 | 1.447180e+05 | -2.262664e+05 | -1.216302e+05 | -2.248020e+05 |
| 6.036663e+05 | -4.637695e+05 | 1.089268e+06 | 1.784283e+05 | -2.085165e+06 | 6.890615e+02 | 1.614015e+06 | -1.208278e+06 | 1.008616e+06 | 2.942320e+05 | 1.447180e+05 | -2.262664e+05 | -1.216302e+05 |
| -5.874450e+05 | 6.036663e+05 | -4.637695e+05 | 1.089268e+06 | 1.784283e+05 | -2.085165e+06 | 6.890615e+02 | 1.614015e+06 | -1.208278e+06 | 1.008616e+06 | 2.942320e+05 | 1.447180e+05 | -2.262664e+05 |
We are able to execute it in python, but when tried in alteryx we are facing issue.
Some guidance will be much appreciated!!
Thanks
