topic Re: Need to restrict rows in QlikView

Need to restrict rows

swati_rastogi27 — Tue, 21 Jun 2016 11:42:29 GMT

Hi experts,

I have 2 tables :

Table 1 : Loan

Table 2 : Excludes

I have to exclude loans from Table 1 which exist in Table 2

Table 1 : Loans

Loan_Number

Table 2: excludes :

Loan_Number

Final Output : Table 1: Loans

Loan_Number

Can anyone help?

Re: Need to restrict rows

giakoum — Tue, 21 Jun 2016 11:54:04 GMT

exclude:

LOAD * INLINE [

exclude

];

loans:

load *

where not Exists(exclude,loans);

LOAD * INLINE [

loans

];

Re: Need to restrict rows

giakoum — Tue, 21 Jun 2016 11:56:25 GMT

Make sure you have not duplicate loan_numbers, otherwise this will not work

Re: Need to restrict rows

Anonymous — Tue, 21 Jun 2016 12:07:33 GMT

First:
LOAD * Inline [
    Loans 
    1
    2
    3
    4
    5
    6
    7
];

Second:
LEFT JOIN (First)
LOAD *,
     1    as Exits;
LOAD * Inline [
    Loans 
    1
    2
    3
];

Final:
NoConcatenate
LOAD
    Loans
RESIDENT First
WHERE IsNull(Exits);

DROP TABLE First;

Re: Need to restrict rows

swati_rastogi27 — Wed, 22 Jun 2016 05:19:18 GMT

We do have duplicate data in the main(Loans) table.

Can you suggest an alternative?

Re: Need to restrict rows

Digvijay_Singh — Wed, 22 Jun 2016 05:35:28 GMT

Try this may be -

Table2:

Load * inline [

Loan_Number_Exist

3 ];

Table1:

Load * inline [

Loan_Number

7 ]

Where not exists(Loan_Number_Exist,Loan_Number);

Drop Table Table2;