Join two columns

[Anonymous]

Guys,

I need to join different columns from two tables into a single column.

I have two tables temp1 and temp2. In temp1 "Date" and "sheet_date" in temp2, these two fields are of date values.

I want these two fields to be combined as single field or column. So I have used the below code, but the output was not as I expected.

temp1:

LOAD EmployeeID,

      Date,

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

FROM

[..\RM_Extracted_QVD\EXT_presentEmpInfo000.qvd]

(qvd);

Join

temp2:

LOAD ProjectID,

     sheet_date,

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

     ProjTaskID,

     worked_hours,

     Billable,

     EmployeeID,

     UserName as FullName

FROM

[..\RM_Extracted_QVD\EXT_ResourceTimesheet.qvd]

(qvd);

Output which I got:

I have combined Date and sheet_date into a single field as "Date". But in the above screenshot, multiple values repeated for the same date as you can see.

Output which I expect:

Please suggest some other ways to achieve this.

[PrashantSangle]

Hi,

In temp1 try

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

and In temp2

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

Regards,

Prashant

[ahaahaaha]

May be use

LOAD Distinct

....

[qlikview979]

Can you please share the qvd's

[Anil_Babu_Samineni]

May be use DISTINCT keyword