I have two tables with many to one relationship (Sales Order Detail and Sales Order Header), I need to create a Sales Fact table and I am wondering whether I should do this on the DW side or while loading the tables in qlikview.
If I wanted to do it in qlik, what do you think I should do to divide the tax amount in Header table between the related rows in fact table?
I might come up with a SQL statement to do it in DW, but in qlik I am not really sure how I can do it.
Re: Merging tables on Data warehouse or in qlikview?
Consider the attached image, I have two tables and I want to merge them while loading in Qlik. When joining the tables, Freight should be broken down into all the joined rows of Detail table. How to divide the amount of freight between the transactions in sales detail table when joining in qlik.