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

[binuacs]

Spoiler

[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

[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 @binuacs 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

[Rhitik_Krishnani]

Dan

My sincere thank to you

You have helped me lot to get what I wanted to achieve.

Just one thing more to add on in the use case.

I also have to add the manufacturing date which should be before the inventory date.

Expiry date which can be random dates after manufacturing in MY Format.

I have to subtract and get the months of expiry as well.

Then I have to forecast it.

I hope you have understood.

You can also give your inputs to make the use-case as best as possible.

I will be really grateful.

~Rhitik Krishnani

[Rhitik_Krishnani]

I am attaching the flow which I modified.

Please update in this flow which includes Manufacturing date, expiry date to get the expiry months

The forecast the Units Sold and modify the use case to make it more relevant.

My sincere Thanks @danilang