Predictive Analytics data table

[Former Member]

Hi All

If one looks at the PAL and for example Triple Exponential Smoothing, the data table has the following layout:

Column 1: ID

Column2: Raw Data

If my source data is Material, Time, Qty. I can create an id for each material/time combination. If I get a new material, the ID starts at one again.

That requires a loop and infeasible when I have a large number of columns, say adding customer, company code etc.

Is there any way to perform the analysis without performing a loop?

Any help would be appreciated.

[achab · Accepted solution]

I am not sure to fully get the question. Can you please add some screenshots explaining your data model? Then we can see how to map this with our existing solutions. Kind regards Antoine