topic Re: How to exclude data available from other table in QlikView

How to exclude data available from other table

Mon, 12 Dec 2016 10:46:40 GMT

I was trying to load a table using SQL join , but its seems this is not supported.

is there any other way to do it during the load

Table1 Table2

Date|Name|X|S Date|Z

I would like to load all data in table1 but to exclude the matched records in table2.

How can I achieve this?

Anonymous — Mon, 12 Dec 2016 13:05:58 GMT

[Table1]:

Load Date, Name, X, S

from [YourTable1];

concatenate(Table1)

Load Date, Z

from [YourTable2]

where not exists(Date);

Anonymous — Mon, 12 Dec 2016 13:18:29 GMT

Try this:

Mon, 12 Dec 2016 18:32:12 GMT

Thank you Marcio.

This was not right solution.

I managed to solve this by using resident and where not exists.

Anonymous — Mon, 12 Dec 2016 18:34:58 GMT