topic Re: Database not found error There is no open data connection. in QlikView

Database not found error There is no open data connection.

Nynaeve88 — Sat, 16 Nov 2024 04:44:50 GMT

Hi,

I'm trying to left join two tables of unequal length. However, I get the following two errors:

(1) Database not found error There is no open data connection. QVTable:
SELECT * FROM OGE

(2) Database not found error
There is no open data connection.
Left Join Select * FROM KNMI_20110708

Based on the other discussion with this topic I tried copying my code to a new file but this didn't solve the issue.

When I remove the join code the script is working again.

I'm using the below script

Please help?:)

LOAD
[Exploitatie ingangsdatum],
[OGE Bouwjaar],
[OGE Energie Label Empire (Empire)],
Year([Exploitatie ingangsdatum]) as Exploitatiejaar
FROM
[D:\X\BM-case\OGE.xlsx]
(ooxml, embedded labels);

LOAD YYYYMMDD as [Exploitatie ingangsdatum],
FHVEC as Windsnelheid,
TG as [Temp gem],
TN as [Temp min],
TX as [Temp max],
RH as [Regen]

FROM
[D:\X\KNMI_20110708.txt]
(txt, utf8, embedded labels, delimiter is '\t', msq);

QVTable:
SELECT * FROM OGE;

Right Join Select * FROM KNMI_20110708;

Re: Database not found error There is no open data connection.

Nynaeve88 — Wed, 16 Jan 2019 11:07:26 GMT

Obviously I'm using Left Join instead of Right join. I tried using the other function to see if that might work and copied that code.. No luck there though.

Re: Database not found error There is no open data connection.

jerrysvensson — Thu, 17 Jan 2019 07:58:00 GMT

QVTable:
SELECT * FROM OGE;

left Join (QVTable)

SQL Select * FROM KNMI_20110708;

Should work.

Re: Database not found error There is no open data connection.

Nynaeve88 — Thu, 17 Jan 2019 10:02:24 GMT

I still get this error:

Database not found error

There is no open data connection.

QVTable:
SELECT * FROM OGE

The problem really lies with connecting to the data tables via the select function I think.

Trying to solve another issue I found the following solution that uses the left join function without using select :

LEFT JOIN(PRELOAD1)
LOAD * RESIDENT PRELOAD2;

DROP TABLE PRELOAD2;