Employee lists

[rassanbekov]

Hello!

I have faced the problem. There are two lists of employees.

First contains the employee names for all departments.

The second contains only one department employees.

The data should be filtered by the one department employee only.

When I use "as" in script, the employees are properly matched. But the data for other employees are also loaded. How can I stop loading the data for all employee in Qlikview?

[jmvilaplanap]

Hi,

Don't load the employees field of the second table, just comment that line.

Regards

[rassanbekov]

Could you please specify?

I should somehow restrict loading...

[jmvilaplanap]

For example:

Table1:

LOAD

     Field1,

     Employee,

     Department

FROM table1

Table2:

LOAD

     Field1,

     Field2,

     Field3,

     Department

FROM table2

In the second load there is not the Employee field

[rassanbekov]

In my case, employee name is a key (link between two files).

[ksomosera10]

Hi Ruslan,

Remove the field that causes the load of Employees, This will stop it from getting catch up during load times.

[rassanbekov]

Could you please clarify?

[ksomosera10]

Can you show your script so that I could specify what you need to work out?

[jmvilaplanap]

Can you share an example of you have and what do you want?

Thanks

[d_prashanthredd]

Hi Ruslan,

You mean that you are having two tables, one with several departments and respective employees and other table with only one department employees.

Now, you want to load the data belongs to the one department only.. ryt??

Straight away you can go for Inner Join..

If, my understanding is wrong, please help me in understanding or provide some sample data.

Thanks,

Prashanth.