Help needed to generate the data

Rhitik_Krishnani

Hello,

I want to generate data something like below

Inventory Id Month Inventory Category Quantity Sold

12345 Jan-18 Household 500

32145 Jan-18 Stationary 600

65789 Jan-18 Personal Care 700

Similarly, I want for all months till Dec-2021

Inventory Id : Random No between 1000, 9999

Month - Month - Year

Inventory Category - 3 categories mentioned above

Quantity Sold : Random no between 100 to 1000

I am new to alteryx.

Please help me out.

~Thank You

Rhitik Krishnani

Workflow

Accepted answers

All comments

binu_acs

Spoiler

Random_Data.yxmd

Rhitik_Krishnani

Hello,

Can you help me on the last thing please, it will really kind.

How to apply ETS and ARIMA and compare the 2.

I know the basics but I am anble to configure.

I have to forecast qty needed in 2021 for all 3 categories of ineventory

Rhitik_Krishnani

I am getting this error when I am running the flow

Screenshot (16).png

Rhitik_Krishnani

I have solved the problem

Thank you

Please asssist me with the forecasting thing

danilang

Hi @Rhitik_Krishnani

Here's the basics of how you would forecast using the two models and compare the models starting from @binu_acs workflow

Crosstab the data, to get the 3 type into individual columns. Feed the data into the two tools selecting the field you want to forecast. I used Household for both, but in this case it doesn't matter since the 3 types have exactly the same amounts. Union the two O(Object model) outputs and feed them into the L input of the TS compare tool. Feed your data in the R input and run the workflow. The I output gives you an interactive graph of the results.

In this case, the two models can't do much with your input since there's only one year and it's random. There's no trend and no seasonality so the output for both tools is a flat forecast.

When investigating new tools, it's always helpful to look at sample workflows that ship with Alteryx. For the TSCompare tool look in Help->Sample Workflows->Learn one tool at a time->Time Series->ETS ARIMA TSCOMPARE TSForecast. This workflow uses a multi-year data set that has both trends and seasonality so the output show the forecast differences between the two models

Dan

Random_Data with forecast.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703