Matching 2 columns and deriving third column from other table

vaibhav11 — Wed, 04 Apr 2018 11:54:07 GMT

HI,

I have a scenario where i have below details in as Fact table:

SalesorderID|TerritoryID||Orderdate

and another table with below details:

TerritoryID|SalespersonID|StartDate|Enddate

this second table shows each SalespersonID with history data for each territory he has lived in and is currently associated to,

as in if the End date is nulll that means at the current time he is a salesperson of this territory or for the previous period,he was a salesperson of this territory

i have to finally check the SalespersonID associated with each SalesOrderID

based on the conditions as :

for each territoryID and salesorderID in the first table , if for that territory obtained from first table,the orderdate lies between Start date and End Date,the corrresponfing SalespersonID is what the salesperson for that time is.

Can any body help me with this?

Re: Matching 2 columns and deriving third column from other table

sunny_talwar — Wed, 04 Apr 2018 11:56:51 GMT

You need Extended Interval Match‌ here

Re: Matching 2 columns and deriving third column from other table

vaibhav11 — Thu, 05 Apr 2018 05:18:26 GMT

Thanks Sunny!! it worked

topic Matching 2 columns and deriving third column from other table in QlikView

Matching 2 columns and deriving third column from other table

Re: Matching 2 columns and deriving third column from other table

Re: Matching 2 columns and deriving third column from other table