Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Like this
myTable:
%FieldA,
FieldB,
FieldC,
etc
myLookup:
%FieldA
where Exists(%FieldA,%FieldA)
let me know if that worked.
Regards
ASHFAQ
Like this
myTable:
%FieldA,
FieldB,
FieldC,
etc
myLookup:
%FieldA
where Exists(%FieldA,%FieldA)
let me know if that worked.
Regards
ASHFAQ
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
Both solutions work fine. Thank you very much.