topic Re: How to Exclude values from two fields? in QlikView

How to Exclude values from two fields?

subbareddykm — Tue, 05 Jan 2016 17:07:10 GMT

Hi All,

I have Table Like this:

Data_Temp:

Load * Inline [

Emp_Role

];

Data:

Load ID,

Employee_Name,

Emp_Role,

Code

From.............. Wher Exists(Emp_Role);

The above Script Will load only Where Emp_Role=X For All fields. But i also want to load only Code =100.So for that what should i do now can any one help me on this.

Re: How to Exclude values from two fields?

sunny_talwar — Tue, 05 Jan 2016 17:25:38 GMT

May be this:

Data_Temp:

Load * Inline [

Emp_Role

];

Data:

Load ID,

Employee_Name,

Emp_Role,

Code

From..............

Where Exists(Emp_Role) and Code = 100;

Re: How to Exclude values from two fields?

subbareddykm — Tue, 05 Jan 2016 17:40:51 GMT

If i do Like that i ll will become un-optimized load right?

Re: How to Exclude values from two fields?

sunny_talwar — Tue, 05 Jan 2016 17:51:06 GMT

Yes it will be an un-optimized load

Re: How to Exclude values from two fields?

subbareddykm — Tue, 05 Jan 2016 17:54:30 GMT

Is there any other solution?

Why bcoz i have huge data so I don't make this un-optimized.

Re: How to Exclude values from two fields?

Anonymous — Tue, 05 Jan 2016 18:19:43 GMT

So the long term answer is to create a multi stage load process and load your data to a QVD file first. Stage all of your data in QVD's and then do your high level load directly from QVD's only.

Re: How to Exclude values from two fields?

Anonymous — Tue, 05 Jan 2016 18:23:13 GMT

How about you create a combined field of [Emp_Role_and_Code].

Then do a suitable Inline load for this and a single Where Exists to get an optimised load.

Re: How to Exclude values from two fields?

maheshkuttappa — Tue, 05 Jan 2016 18:36:10 GMT

‌hi,

i would use below script it would be more faster.

Data_Temp

Load * Inline [

Emp_Role

X ];

Data:

Load

ID,

Employee_Name,

Emp_Role,

Code

From...

where exists(Emp_Role);

inner join (Data)

load * Inline

[ Code

100];

drop table Data_Temp;

Re: How to Exclude values from two fields?

sunny_talwar — Tue, 05 Jan 2016 18:47:20 GMT

Look at what Bill‌ has proposed. I don't know another way of doing it.

Re: How to Exclude values from two fields?

maxgro — Tue, 05 Jan 2016 20:03:51 GMT

Bill solution

or if one of the fields will exclude a lot of records you can try with a 2 step optimized exists:

load inline first field

load optimized (exists) from qvd

store in qvd

load inline second field

load optimized (exists) from last stored qvd