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