topic concatenate in QlikView

concatenate

NavinReddy — Fri, 31 Jan 2014 07:44:37 GMT

Dear All,

I have two QVDs,

One QVD having 2011 data,Second QVD having 2012 data

But both the QVDs having same field names,

if i concatenate both the QVDs how can i get 2011 and 2012 data separately

Thanks In Advance

Niranjan

Michiel_QV_Fan — Fri, 31 Jan 2014 07:47:14 GMT

Add a field which identifies the source, like '2011' as Year in the 2011 data and '2012' as Year in 2012 data.

Fri, 31 Jan 2014 08:21:36 GMT

Hi Niru Niru,

If you have a field with the Data, you can add a field called Year -> Year(Data) as Year, or you can add it manually

LOAD

...

2011 as Year

FROM Qvd2011.qvd (qvd);

LOAD

...

2012 as Year

FROM Qvd2012.qvd (qvd);