topic Re: Hi team in QlikView

Hi team

Kohli — Wed, 25 Nov 2020 16:16:04 GMT

I have two tables. Table1 contains the all student details and Table contains only Passed student ID's. How can i get the only Failed student details.(I want load only fail student detilas).

Table1:

S.ID S.name DOB District

1 xxxxx 10051991 KADAPA

2 yyyyyy 10071991 CHITTORE

3 eeeeeee 05021991 NELLORE

4 ssssss 10051991 ANATAPUR

5. nnnnn 03031991 KADAPA

Table2:

S.ID(Passed)

I want load only fail student details; ( no need to load all table from the file)

EX: OUTPUT

S.ID S.name DOB District

2 yyyyy 10071991 CHITTORE

5 nnnnn 03031991 KADAPA

Re: Hi team

Anil_Babu_Samineni — Wed, 22 Mar 2017 11:44:18 GMT

May be use Not Exists([S.ID]) for your second one

Load * From Table1;

Load * From Table2 where Not Exists([S.ID]);

Re: Hi team

sunny_talwar — Wed, 22 Mar 2017 11:46:29 GMT

I would just change the order here

Load * From Table2;

Load * From Table1

Where Not Exists([S.ID]);

Re: Hi team

neha_shirsath — Wed, 22 Mar 2017 11:48:58 GMT

Hi,

You can use where not exist or you can do -

table 1

right join

table 2

Thanks,

Neha

Re: Hi team

vinieme12 — Wed, 22 Mar 2017 13:10:04 GMT

i think you may need an Alias field here .. no you won;t

Table2:

load * inline [

S.ID

];

load * inline [

S.ID,S.name,DOB,District

1,xxxxx,10051991,KADAPA

2,yyyyyy,10071991,CHITTORE

3,eeeeeee,05021991,NELLORE

4,ssssss,10051991,ANATAPUR

5,nnnnn, 03031991,KADAPA

] where not Exists([S.ID]);

Re: Hi team

Kohli — Fri, 24 Mar 2017 08:55:58 GMT

But i take the same data from database, but it's not working.

ODBC CONNECT TO co;

Table1:

LOAD SID;

SQL SELECT *

FROM mohan.dbo.studentpassdetails;

Table2:

LOAD SID,

Student,

address,

DOB;

SQL SELECT *

FROM mohan.dbo.Studentdetails

where not exists SID;

Please help me

;

Re: Hi team

sunny_talwar — Fri, 24 Mar 2017 08:59:35 GMT

Try putting parenthesis around SID within Where not Exists()

Table1:

LOAD SID;

SQL SELECT *

FROM mohan.dbo.studentpassdetails;

Table2:

LOAD SID,

Student,

address,

DOB;

SQL SELECT *

FROM mohan.dbo.Studentdetails

Where not Exists(SID);

Re: Hi team

Kohli — Fri, 24 Mar 2017 09:05:11 GMT

i got error in this type:

SQL##f - SqlState: 37000, ErrorCode: 102, ErrorMsg: [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'SID'.

SQL SELECT *

FROM mohan.dbo.Studentdetails

where not Exists (SID)

Re: Hi team

sunny_talwar — Fri, 24 Mar 2017 09:09:50 GMT

My bad, try this

Table1:

LOAD SID;

SQL SELECT *

FROM mohan.dbo.studentpassdetails;

Table2:

LOAD SID,

Student,

address,

DOB

Where not Exists(SID);

SQL SELECT *

FROM mohan.dbo.Studentdetails;

Re: Hi team

Kohli — Fri, 24 Mar 2017 10:25:17 GMT

Yes It's working. Thanks sunny.

At the same time, If i have

Table1:

SID1

Table2

SID

How can i use that statement. (where not Exists(SID))

Re: Hi team

vinieme12 — Fri, 24 Mar 2017 10:49:54 GMT

Table1:

SID1

concatenate

Table2

SID

where not exists (SID1,SID);

Re: Hi team

Kohli — Sat, 25 Mar 2017 13:22:26 GMT

But iam getting results like this.....

S.ID,S.name,DOB,District

2,yyyyyy,10071991,CHITTORE

5,nnnnn, 03031991,KADAPA

I need to remove 1,3,4 SID. What can i do for remove that?

Re: Hi team

Sat, 25 Mar 2017 14:54:18 GMT

load * Inline [

S.ID

];

Right join

load * Inline [

S.ID, S.name, DOB, District

1, xxxxx, 10051991, KADAPA

2 , yyyyyy, 10071991 , CHITTORE

3 , eeeeeee , 05021991 , NELLORE

4 , ssssss , 10051991 , ANATAPUR

5 , nnnnn , 03031991 , KADAPA

]

where not Exists ([S.ID]);

Re: Hi team

sunny_talwar — Sat, 25 Mar 2017 19:58:09 GMT

You need to DROP Table Table1; at the end

Table1:

LOAD SID;

SQL SELECT *

FROM mohan.dbo.studentpassdetails;

Table2:

LOAD SID,

Student,

address,

DOB

Where not Exists(SID);

SQL SELECT *

FROM mohan.dbo.Studentdetails;

DROP Table Table1;