Where exists

Thu, 16 Jul 2015 17:54:32 GMT

I have to load 3 tables based on the below table

TeamList:

LOAD [Emp ID] as BankID,

Name,

DOJ,

[Supervisor Name]

From

....................................\TeamList.xls;

Attendance:

LOAD

"[Bank ID]" ,

"[Staff Name]" as [Staff Name],

"[Log Type]" as [Log Type],

FROM

........................Attendance.qvd

(qvd);

Concatenate

Training:

LOAD

[Bank ID] ,

[Staff Name],

LOAD Date,

Team,

[Bank ID],

[Staff Name]

FROM

................\Meeting.qvd

(qvd);

Concatenate

Meeting:

LOAD

Date

[Bank ID] ,

[Staff Name],

Group By Date, [Bank ID], [Staff Name];

LOAD Date,

Team,

[Bank ID],

[Staff Name]

FROM

.................\Meeting.qvd

(qvd);

Based on the [Emp ID] in TeamList Table , i have to load all the other 3 tables and concatenate..

How do i achieve it

Re: Where exists

MK_QSL — Thu, 16 Jul 2015 18:05:35 GMT

Use Where Exists(BankID, [Bank ID]);

Re: Where exists

Thu, 16 Jul 2015 18:38:43 GMT

There are 3 tables named

Attendance,

Meeting,

Training

They are concatenated

My final Concatenated table should have BankID which are present only in TeamList

topic Where exists in QlikView

Where exists

Re: Where exists

Re: Where exists