Load from multiple yearly qvds where year > 2012

[snehamahaveer]

Dear All,

I am trying to load data from multiple qvds and at the moment I am having to type the entire load statement for each qvd.!!

I have looked up a For each statement to upload multiple QVD's however, I am unable to adapt it to my situation. If you can come up with a better solution for my problem - it will be wonderful.

My qvd's are named as Customer_sales_2010 .... Customer_sales_2016

I want to upload all data from Qvd's where year > 2012.

Many thanks in advance!

[marcus_malinow]

Something like:

Customer_Sales:

LOAD *

FROM

Customer_sales_*.qvd

WHERE

right(subfield(filename(), '.', 1), 4) > 2012

;