3 Replies Latest reply: Oct 19, 2016 2:10 PM by Venkata Nerella RSS

    Two Tables Joined in multiple ways

    Venkata Nerella

      HI,

       

      Very new to Qlik.

      I have two tables ,One Master table and One Historical table.

       

      I would like to join both Master and Historical with common keys to get different results.

      For Example:

      Master has Month end Date

      Historical has Transaction Dates.

       

      Join 1# Transaction Date between Month Start Date and Month End Date

      Join 2# Transaction Date between Year Start Date(Extracted from Transaction Date) and Month End Date

       

      I would like to load both these tables and join them in Qlik with different relations.

       

      Whats the best way to do it ?

      Looking at some Youtube Video's I think it can be achieved using load inline function.

       

      Thank you

        • Re: Two Tables Joined in multiple ways
          Gysbert Wassenaar

          Create a Month End Date in your historical transaction table too with the same name as in your Master table. That way the records in both tables will be associated correctly.

           

          I don't understand what you want with regards to join #2.

            • Re: Two Tables Joined in multiple ways
              Venkata Nerella

              Basically I'm trying to achieve MTD and YTD Transactions.

              With Join 1#, I see your suggestion will work

              Similarly Join 2#,If the Master table 1 is looking at Feb Month end, From Transaction, i would like to get all transactions until Feb end.

              If I choose Oct from Master Month end,Then all transactions until Oct from Historical table.

               

              I'm guessing I could join by using <= or something.

               

              But my real question is,

              Can I maintain two different Physical tables and  create views (Create different results set by combining both tables using different joins )

               

              Thanks

            • Re: Two Tables Joined in multiple ways
              Venkata Nerella

              Let me Ask this in a different way.

              I have

              1)Job Opening Table, That has Hiring Manager ID and Recruiter ID.

              2)Hiearchy Table: That has denormalized view with all the levels

               

              I would like to set relations as

              1 )Job Opening Table Hiring Manager ID +  Emplid in Hierarchy table

              2) Job Opening Table Recruiter ID +  Emplid in Hierarchy table