Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts
I got Sales QVDs in a folder from 2014
Sales_2014_01
Sales_2014_02
Sales_2014_03
Sales_2014_04
Sales_2014_05
Sales_2014_06
Sales_2014_07
Sales_2014_08
Sales_2014_09
Sales_2014_10
Sales_2014_11
Sales_2014_12
Now I want to chose the data only from 2014_05
I dont want to load the QVDs one by one
Is there a dynamic Way of Loading it from 2014_05
Please Suggest
LOAD * FROM Sales_*.qvd (qvd)
Where Right(FileBaseName(),7)>='2014_05';
Hi Marco
It was not Working
Please Suggest some Solution
I want to Load QVDs >='2014_05'
Can you post the script you are using?
-Rob