topic Re: Limiting Lookup Table Data Import in QlikView

Limiting Lookup Table Data Import

Wed, 15 Oct 2014 04:42:11 GMT

Hi,

After i load my fact table, my table will have a structure like this:

myTable:

%FieldA,

FieldB,

FieldC,

etc

Now, I need to load in a lookup csv file for %FieldA like so:

myLookup:

%FieldA

otherFields...

but the csv file may contain %FieldA values that are not in the loaded fact table so when I show a listbox on the UI, it displays those "extra" %FieldA values. What is the best approach to drop those extra %FieldA values in the load script when loading the myLookup csv file?

Thanks.

Re: Limiting Lookup Table Data Import

ashfaq_haseeb — Wed, 15 Oct 2014 05:08:18 GMT

Like this

myTable:

%FieldA,

FieldB,

FieldC,

etc

myLookup:

%FieldA

where Exists(%FieldA,%FieldA)

let me know if that worked.

Regards

ASHFAQ

Re: Limiting Lookup Table Data Import

jonathandienst — Wed, 15 Oct 2014 05:20:03 GMT

Use a Left Keep like this:

Left Keep(myTable)

myLookup:

LOAD %FieldA

otherFields...

Will filter out all those that do not exist in myTable.

HTH

Jonathan

Re: Limiting Lookup Table Data Import

Wed, 15 Oct 2014 05:56:09 GMT

Both solutions work fine. Thank you very much.