topic Join table using wildcards on filename in QlikView

Join table using wildcards on filename

Thu, 27 May 2010 19:52:24 GMT

I recently updated my QV to SR4 and today I noticed that one script stop working. The problem occurs when I do a JOIN to a Table using data from more than one QVD (using wildcards). Something like this (where Master is a table with a field called id):

LEFT JOIN (Master)
LOAD id
, Count(DISTINCT subid) AS q
FROM [Master_*.qvd] (qvd)
GROUP BY id;

An example application [View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Components.UserFiles/00.00.01.15.11.Posted/JoinLoadWildcard.qvw].

In this case, I guess that QV does one JOIN for each QVD instead of loading all QVDs and then do the JOIN. As result, I only get a subset of the data joined.

Am I doing anything wrong?

Join table using wildcards on filename

Tue, 01 Jun 2010 09:14:54 GMT

Hi,

I don't think that SR4 is the problem. In previous versions it also wasn't possible to do what you want to do.
The way we work:

tt_table:
LOAD id
, Count(DISTINCT subid) AS q
FROM [Master_*.qvd] (qvd)
GROUP BY id;

LEFT JOIN (Master)
LOAD
*
RESIDENT tt_table;

DROP TABLE tt_table;

Join table using wildcards on filename

Tue, 01 Jun 2010 13:58:24 GMT

You're right. I tried the previous version and behaves the same way. I'm using a resident temp table as workaround. Thanks!