topic Re: How do I connect data from two tables for training my first Qlik Automl experiment in Qlik Predict

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

HenryE — Fri, 29 Aug 2025 15:17:08 GMT

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.

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

Lisa_P — Sun, 31 Aug 2025 23:47:22 GMT

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.

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

HenryE — Mon, 01 Sep 2025 16:24:00 GMT

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.

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

Lisa_P — Tue, 02 Sep 2025 23:58:07 GMT

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.

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

HenryE — Wed, 03 Sep 2025 07:29:08 GMT

Thank you.