Limiting Lookup Table Data Import

[#1]

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.

[ashfaq_haseeb · Accepted solution]

Like this

myTable:

%FieldA,

FieldB,

FieldC,

etc

myLookup:

%FieldA

where Exists(%FieldA,%FieldA)

let me know if that worked.

Regards

ASHFAQ

[jonathandienst]

Hi

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

[#4]

Both solutions work fine. Thank you very much.