Concate two different Field from tow different QVD in Qlikview

[SK28]

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

[Gysbert_Wassenaar · Accepted solution]

Temp:

LOAD Location FROM locations.qvd'(qvd);

JOIN (Temp)

LOAD Time FROM Time.qvd (qvd);

Result:

LOAD Location & '-' & Time RESIDENT Temp;

DROP TABLE Temp;