Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Combine tables without common entry

Hi Team,

I have two table :

Table1: Holds all employee details without  0 planning hours(<>0)

Table2: Hold all employees with zero planning hours.(=0)

Fileds name-Employee name,Project code,week,planning hours.

So there are chances that employees in table 1 may be in table 2 for some week.

Hence, I wont a table which holds data from table1 and table 2 but make sure

In case there are same employee in table1 and table2 , we should keep the one in table 1(<>0).

Kindly assist.

Thanks,

Prajna

10 Replies
Not applicable
Author

Sorry some syntax problem..i corrected.Its coming.

But does it give employees from table 1 alone,I need employees in table 2 as well .

in case they are not present in table1.

As per example Ramya.I am not getting employees with 0 hours.

Regards,

Prajna