2 Replies Latest reply: Dec 14, 2017 10:52 AM by Sunny Talwar RSS

    Query Fact and Dimension tables in load script and create new table

    Michael Simonsen

      In my load script I first load a Fact table and 10 dimension tables.


      How can I in the load script create a new table, which is a subset of the total "FactDimension" table based on values in the dimension tables.


      In SQL, it would be something like:


      Create table

      Select * from Fact

      left join ....

      left join ....

      where dim1.fieldA = "aaa" and dim2.fieldB = "bbb" and ...


      How can i do this without having to join my Fact table and the 10 dimension tables in the load script.


      In other words, how can I in the load script filter data in the same way as when the load script is completed and data is loaded into Qlik Sense.


      Thank you in advance for all ideas.

      Michael