Concate two different Field from tow different QVD in Qlikview

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

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

Re: Concate two different Field from tow different QVD in Qlikview

Gysbert_Wassenaar — Thu, 22 Sep 2016 16:43:06 GMT

Temp:

LOAD Location FROM locations.qvd'(qvd);

JOIN (Temp)

LOAD Time FROM Time.qvd (qvd);

Result:

LOAD Location & '-' & Time RESIDENT Temp;

DROP TABLE Temp;