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]

You are right, sorry...

Can you share a sample file, please?

Marc.

[#3]

Thats ok

I have attached a sample xls

the database table is just a simple table that holds businessname, address etc

[Anonymous]

Please Find Attached.

Marc.

[#5]

Ok...I see

But if I add the BusinessName Column to the Tablebox, it adds in Ark Dental Practise...I need this to not show up at all

[Anonymous]

In case you do not need excluded vales, then drop Leads table in script:

Drop table Leads;

Marc.

[#7]

Errmm... No i need Leads table

I need all the values in Leads except the ones that are in the excel...does that make sense?

[Anonymous · Accepted solution]

Well, depending on the requirements it will make sense or not. Check attached again and compare table object and table chart object.

I hope it clarifies your doubts.

Marc.

[#9]

Ok the chart object makes sense...but when i do it with my full data it tells Allocated Memory exceeded.

Not going well for me

[Anonymous]

Vaishali,

I understand your initial requirement was accomplished. Please close this thread and open a new one to solve your Memory error.

Marc.