Concatenate within a loop

[Anonymous]

Hi All,

I have 3 monthly QVDs .What i wish to achieve is make one single QVD containing data of 3 months

I need to achieve under a loop as the QVDs to be fetched are dynamic based on variables

I can't use load * because based on current month last 3 months will keep changing.

Any help appreciated .

Thanks and Regards,

Nishant Nadkarni

[Peter_Cammaert]

Can you post a few more details? What do you mean by "...QVDs to be fetched are dynamic based on variables..."? What do those variables contain? And what are the names of the QVD files?

Best,

Peter

[Anonymous]

Hi Peter,

QVD names are like Fact_$(vMonth1),Fact_$(vMonth2),Fact_$(vMonth3)

and the variables vMonth1 ,vMonth2 and vMonth3 contain values for last 3 months

eg. Apr-2016,May-2016,June-2016 ...

I have written this inside a loop and at the end I am storing this concatenated data inside a single QVD .My final QVD contains data only for June-2016 whereas what I need is data for all 3 months.

Thanks and Regards,

Nishant Nadkarni