New column based on two columns from two tables

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

hi guys,

I have two tables as two qvd as data sources.

table 1: (EXT_presentEmpInfo.qvd)

LOAD EmployeeID,

FullName,

Date(Date,'MM/DD/YYYY') as Date

FROM

(qvd);

table 2: (EXT_ResourceTimesheet.qvd)

LOAD EmployeeID,

sheet_date,

worked_hours

FROM

(qvd);

I have Date in table 1, it contains the all the dates of an employee from the joining till today. In table 2, sheet_date has all the dates of an employee who has worked alone from the joining till today.

I need a table exactly as shown in below table by combining these two tables,

I have tried below codes but not worked,

Present:

LOAD EmployeeID,

Date(Date,'MM/DD/YYYY')as Date

FROM

(qvd);

left join

Timesheet:

LOAD EmployeeID,

Date(sheet_date,'MM/DD/YYYY') as Date,

1 as Flag

FROM

(qvd);

My output for this code is as shown below,

I have also attached my real data along with this. Please help.

Regards,

Yoganantha Prakash G P and Bose

topic New column based on two columns from two tables in QlikView

New column based on two columns from two tables