Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
Announcements
Gartner® Magic Quadrant™: 15 YEARS A LEADER - GET THE REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
jjustingkm
Creator II
Creator II

Qlik data load

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

Labels (1)
3 Replies
aruneshgupta
Creator
Creator

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 

jjustingkm
Creator II
Creator II
Author

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

aruneshgupta
Creator
Creator

Yes