Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

New Contributor III

Script Join Problem

Hi All,

I am hoping you can come to my rescue with respect to an issue I am having.

My database has buildings; each building is assigned to a property.  SO my gbbuilding table has (for example):

Building     Property

1               A

2               B

3               B

4               C

5               D

6               D

And so on.

I have a booking table, which includes a building code.  There is a table I need to join to that has several fields in common, but instead of the building code, it has the property code.  How the heck do I join these from the SQL statement standpoint?


FROM cmsvbook b LEFT OUTER JOIN cmprovable p

ON b.service_type=p.service_type

    AND b.service_detail=p.service_detail

    AND b.provider_code=p.provider_code

   and b.building_code=p.property_code; 

This was how it was written long before I got the view, and might have worked in theory once upon a time.  It's now wrong because, for many of my clients these days, the building code and property code can be, and  usually are, different.  I need to "go through" gbbuilding and swap out the b.building_code for the correct property code that I need.

Does anyone know how to make this work?


Tags (3)
2 Replies
Honored Contributor

Re: Script Join Problem

Hi Rayna,

Sorry for such a idea. Can make sense first to directly download all the tables from SQL to Qlik, and only then to impose conditions and bind them between themselves?



New Contributor III

Re: Script Join Problem

HI Andrey,

Thank you for your message.  I fear I don't understand what this means?

Community Browser