topic Can we Make a Forced Join on two Tables in QlikView

Can we Make a Forced Join on two Tables

Mon, 23 Sep 2013 19:24:18 GMT

I have a situation where I have two tables, and we should not have a common element in both the tables, as the results are ambiguous when we have the ID's as Common. However in one calculation I need to check the common rows for which I need to join them, can we Impose a forced Join on two tables with different names.

Ex: A.EmployeeID = B.EmployeeID

Re: Can we Make a Forced Join on two Tables

rbecher — Mon, 23 Sep 2013 20:49:34 GMT

Hi,

I think this can work only in the load script:

JOIN(A) LOAD B.EmployeeID as A.EmployeeID Resident B;

- Ralf

Re: Can we Make a Forced Join on two Tables

Fri, 27 Sep 2013 16:54:36 GMT

Thanks Ralf,

I tried this, yes it work only in the script level.