Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have a table with values of names like
tab1
load * inline [
name
apple
pear
...
(a lot of names)
]
how i can specify my load statement if i want to add in qlik only values that matching with values from tab1
try to use wildMatch like : Where WildMatch([Fruits],'tab1')<>0 but i don't know how to coorectly specify it to match my values from field [fruits] with each values of tab1
without joins
Try using Exists(), like:
Where Exists(name, Fruits)
JG