Discussion Board for collaboration on QlikView Scripting.
I have a problem with my Skripting.
I join two Tables to one.
But I want only the elements, where the [Object-ID] is not included in Table1
(ooxml, embedded labels, table is Aufgaben);
join load distinct
[..\30_QVDs\Aufgaben.qvd] where ...............
I hope someone can help me.
Go to Solution.
Try this script it will work
where not exists([Object-ID];
Add this line of code:
where not exists([Object-ID]
to the 2nd load statement.
So the 2nd load statement turns into this:
Unfortunately it does not work:
Error opening file '..\30_QVDs\Aufgaben.qvd where not exists [Object-ID' The system cannot find the file specified.
[..\30_QVDs\Aufgaben.qvd] where not exists [Object-ID]
Are you sure you need join, all your field names in both the tables are same, you may want to use concatenate.
You can also try this script,
Try like this
// since both the tables have similar columns it will automatically gets concatenated
Thanks. You are all right. But my problem is not to connect the two tables.
I like only the elements where the Object-ID is NOT in the first Table.
the result should look like this:
where not exists([Object-ID])
Do you want to JOIN or CONCATENATE?