Load from multiple yearly qvds where year > 2012

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

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!

Re: Load from multiple yearly qvds where year > 2012

marcus_malinow — Tue, 21 Jun 2016 15:47:38 GMT

Something like:

Customer_Sales:

LOAD *

FROM

Customer_sales_*.qvd

WHERE

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

;

topic Load from multiple yearly qvds where year > 2012 in QlikView

Load from multiple yearly qvds where year > 2012

Re: Load from multiple yearly qvds where year > 2012