concatenate

[NavinReddy]

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]

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

[#3]

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);