topic Re: Qlik data load in App Development

Qlik data load

jjustingkm — Tue, 20 May 2025 15:42:56 GMT

I have to load 3 tables like below. Can you suggest what is the best method to load these tables, do I have to load them independently and join (syncretized keys will come) or do I need to concatenate and load them as one single table?

TABLE A YEAR MONTH REGION PRODUCT DEPARTMENT SALES SALES_QUANTITY

TABLE B YEAR MONTH REGION PRODUCT DEPARTMENT ORDER ORDER_QUANTITY

TABLE C YEAR MONTH REGION PRODUCT DEPARTMENT CUSTOMOER ID CUSTOMER NAME PRESHIMPMENT VOLUME PRESHIMENT_QUANTITY

Re: Qlik data load

aruneshgupta — Tue, 20 May 2025 20:59:21 GMT

The best approach is to merge all fact tables together, create a calendar table, and link all dimension (master) tables to the merged fact table.

Best Regards,

Arunesh Kumar

Re: Qlik data load

jjustingkm — Tue, 20 May 2025 23:24:48 GMT

thanks. When you say merge, you are saying to concat the tables, correct?

Re: Qlik data load

aruneshgupta — Wed, 21 May 2025 00:46:06 GMT

Yes