5 Replies Latest reply: Jul 25, 2013 9:25 AM by Stefan Wühl RSS

    Combining multiple tables with same/similar structure

      Hello,

       

      I am new to Qlikview, and developing a series of reports on Qlikview 10.

       

      Our data warehouse stores different years of sales data in different tables, with some new fields added in the most recent table and the tables do not have a primary key. If I load the tables separately, will Qlikview be able to link them appropriately? E.G. Will I be able to sum sales across years stored in different tables? How will this be affected by the new fields in the latest table?

       

      If not, how would I go about combining the tables into one. When using Access, I create a table with the structure I need, then append the data from each year. One of the big problems with this is that I quickly hit Access's file size limit, so I have to summarize the data before I can combine it.

       

      Here's a quick mockup of what the two different tables would look like, with an excerpt of some of the fields I'd be using. The field names are identical, except the newer table has more fields I need to incorporate. What is the best way to incorporate data from all the tables (there are at least 6 I'd be pulling from). Also, the current table is named Sales_Journal. When the year turns, the data gets dumped into a new table Sales_Journal_201x. I don't imagine this would be problematic, but I'd prefer to cover my bases - would there be any problem with that?

       

      Invoice_no
      Invoice_date
      Sales_type
      Ship_Qty
      Ext_Dlr_Net
      651356305/12/2012LP951.26

      Invoice_no
      Invoice_date
      Sales_type
      Ship_Qty
      Ext_Dlr_Net
      Origin
      856352606/17/2013NS22.36web portal