topic Re. :Re: Re. :Attaching an inline table with unsued values in QlikView

Attaching an inline table with unsued values

Fri, 14 May 2010 13:26:54 GMT

Hello

I am loading a CSV table into my QV application. I've also loading an inline table which maps a single letter code field in the CSV file to a description of that code. The problem is that not all the codes are currently used in the CSV, but, once loaded, the application shows these unused codes in list boxes and they appear in the tables/charts as extra, empty, rows.

How do I prevent the unused codes in my inline table from appearing in the application? I tried using left join, but that doesn't seem to work.

Can anyone help?

Re. :Attaching an inline table with unsued values

martin59 — Fri, 14 May 2010 13:32:47 GMT

Could you send an extract of your script ?

Martin

Re. :Attaching an inline table with unsued values

Fri, 14 May 2010 13:50:39 GMT

Since sending my first message I've been experimenting with it. Originally my script loaded in the CSV and then there was an inline table as follows:


left join load * inline [
code, code_desc
A, Alpha
B, Beta
C, Charlie];

But this inline table was on a different script tab and the unused codes still appeared in my application. I moved this code onto the same tab as the CSV load script and now it seems to work.

Is there some priority or grouping applied to the script tabs?

Hope that makes sense! Thanks.

Re. :Re: Re. :Attaching an inline table with unsued values

martin59 — Fri, 14 May 2010 13:54:29 GMT

When you use JOIN without parameter, you join with the last table loaded.

If you want to join with another table, you have to precise the name like this :

LEFT JOIN (table_to_join)
LOAD ....

Martin