6 Replies Latest reply: Apr 7, 2017 10:18 AM by Anil Babu RSS

    Merging tables on Data warehouse or in qlikview?

    ar eiuiew

      Hi Guys,

      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.

       

      Thank you so much for your answer

      Regards

      Ashanti