Join two columns

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

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.

Re: Join two columns

PrashantSangle — Mon, 29 May 2017 11:35:28 GMT

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

Re: Join two columns

ahaahaaha — Mon, 29 May 2017 11:36:11 GMT

May be use

LOAD Distinct

....

Re: Join two columns

qlikview979 — Mon, 29 May 2017 11:36:26 GMT

Can you please share the qvd's

Re: Join two columns

Anil_Babu_Samineni — Mon, 29 May 2017 11:37:58 GMT

May be use DISTINCT keyword

topic Re: Join two columns in QlikView

Join two columns

Re: Join two columns

Re: Join two columns

Re: Join two columns

Re: Join two columns