Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
SK28
Creator
Creator

Concate two different Field from tow different QVD in Qlikview

Hi,

Is it possible to Concate two different Fields from two different QVD into one single Field.

For Example:

I'm having two below mentioned QVD's

*) Locations QVD

*) Time QVD.

locations:

USA

CANADA

Time:

1/09/2016

2/09/2016

.

.

30/09/2016

is it possible to get output as show below:

Location+Time

USA - 1/09/2016

USA - 2/09/2016

USA - 3/09/2016

.

.

so on

USA - 30/09/2016

CANADA- 1/09/2016

CANADA- 2/09/2016

CANADA- 3/09/2016

.

.

so on

CANADA- 30/09/2016

Thanks in Advance.

Krishna

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Temp:

LOAD Location FROM locations.qvd'(qvd);

JOIN (Temp)

LOAD Time FROM Time.qvd (qvd);

Result:

LOAD Location & '-' & Time RESIDENT Temp;

DROP TABLE Temp;


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar

Temp:

LOAD Location FROM locations.qvd'(qvd);

JOIN (Temp)

LOAD Time FROM Time.qvd (qvd);

Result:

LOAD Location & '-' & Time RESIDENT Temp;

DROP TABLE Temp;


talk is cheap, supply exceeds demand