Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

raynac
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?

SQL SELECT *

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?

TIA!

Tags (3)
2 Replies
ahaahaaha
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?

Regards,

Andrey

raynac
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