topic Re: Two Tables Joined in multiple ways in Connectivity & Data Prep

Two Tables Joined in multiple ways

nvrphanikumar — Mon, 17 Oct 2016 19:30:37 GMT

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 — Tue, 18 Oct 2016 09:24:10 GMT

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

nvrphanikumar — Tue, 18 Oct 2016 13:00:26 GMT

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

nvrphanikumar — Wed, 19 Oct 2016 18:10:57 GMT

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