Where Exists

Wed, 22 Jul 2015 11:30:12 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

My Final table should have BankID which is present on TeamList Table

Re: Where Exists

pokassov — Wed, 22 Jul 2015 11:31:49 GMT

where exist(BankID,[Bank ID]);

topic Where Exists in QlikView

Where Exists

Re: Where Exists