How do I connect data from two tables for training my first Qlik Automl experiment

[HenryE]

Hi everyone, 

I am working on my first Qlik Automl experiment and I need to use data from two excel files for the model training. I would appreciate if anyone could give me some guide on how to go about this.

Thank you. 

[Lisa_P]

Can you give a sample or example of the files you are looking to use? Typically we will have one file for training and another for dong predictions.

[HenryE]

I am trying to forecast sales quantity. I have data on 2 excel files, one has the sales data while the other has data on factors that can influence sales. I plan to join them using the month columns on both sheets but I am struggling to do this on Qlik Automl.

Please find data sample in the screenshot below.

Thank you.

[Lisa_P · Accepted solution]

You will need to prepare the data before creating the experiment. As you want to join the tables on the MonthYear and this is not the lowest granularity, you will also need to aggregate the precipitation, GTI Count and GTE Count  in the second table to a monthly value or you will get repetition in the joined table which is not then giving one row of data per Invoice Cust.

You could do this in another app or script to create the one table. 

[HenryE]

Thank you.