Exclude values from excel spreadsheet when loading sql data

[#1]

Hello

I am bit of a novice on Qlikview and can't seem to find a way of effectively excluding some data.

So the scenario is I have some data in an excel spreadsheet and I have master data in a sql table, I need to exclude the values that are in the spreadsheet when loading the sql data.

I have so far

Leads:

Select

BusinessName

FROM CampaignManagement..[Leads] L

where enddate is null;

Load

BusinessName,

address,

post_code,

phone,

email,

url

FROM

(biff, embedded labels, table is Adverisers$);

Where the business name in the excel file matches a business name in the Leads table, I need that row excluded.

Any help would be appreciated

[Anonymous]

Hi,

Try adding this :

...

FROM

(biff, embedded labels, table is Adverisers$)

where not(exists(BusinessName));

Marc.

[alexandros17]

try with

Leads:

Select

BusinessName

FROM CampaignManagement..[Leads] L

where enddate is null;

Load

BusinessName,

address,

post_code,

phone,

email,

url

FROM

(biff, embedded labels, table is Adverisers$)

where not exists(BusinessName, BusinessName);

let me know

[#4]

Neither of the above is excluding the records

[Anonymous]

My previous solution may work if you have not loaded your BusinessName before. So I assume you need another way, let's try with:

Leads:

Select

BusinessName

FROM CampaignManagement..[Leads] L

where enddate is null;

Table1:

Load

BusinessName,

address,

post_code,

phone,

email,

url

FROM

(biff, embedded labels, table is Adverisers$);

left join (table1) load *, 1 as excludename resident Leads;

Table2: noconcatenate load * resident Table1 where excludename<>1;

drop table Table1;

Marc.

[#6]

I get an error

Table not found

left join (table1) load *, 1 as excludename resident Leads

Field not found - <excludename>

Table2: noconcatenate load * resident Table1 where excludename<>1

[Anonymous]

Please name your table. See where I typed "Table1" before load statement.

Marc.

[#8]

I think I have ??

Leads:

Select

BusinessName

FROM CampaignManagement..[Leads] L

where enddate is null;

Table1:

Load

BusinessName,

address,

post_code,

phone,

email,

url

FROM

(biff, embedded labels, table is Adverisers$);

left join (table1) load *, 1 as excludename resident Leads;

Table2: noconcatenate load * resident Table1 where excludename<>1;

drop table Table1;

[Anonymous]

ok, then force the no-concatenation. Please add this before load statement:

Table1: Noconcatenate

Marc.

[#10]

It was

left join (table1) load *, 1 as excludename resident Leads;

should have been

left join (Table1) load *, 1 as excludename resident Leads;

ANYWAY...still not excluding the data

Sooo strange