topic File with format in QlikView

File with format

Anonymous — Thu, 18 May 2017 08:36:17 GMT

If I have list of Qvd in the format Sale_201603.qvd ,Sale_201709.qvd and Sale_UAT_201702.qvd ,Sale_201709-Copy.qvd and

How I can pick all the files with Sale_YYYYMM format only

MindaugasBacius — Thu, 18 May 2017 09:03:55 GMT

I think From path\Sale_2* might work

avinashelite — Thu, 18 May 2017 09:08:42 GMT

Try like this

Path\Sale_*.QVD will load all the files which starts with Sales_

Path\Sale_2*.QVD

jonathandienst — Thu, 18 May 2017 09:18:41 GMT

Perhaps

Path\Sale_??????.QVD

or test explicitly for numeric values in the YYYYMM portion:

For Each vFile in FileList('Path\Sale_*.qvd')

Let vTestStr = TextBetween(vFile, '\Sale_', '.qvd');

Let vTest = IsNum(vTestStr) and Len(vTestStr) = 6;

if vTest Then

LOAD *

FROM [$(vFile)]

(....)

End If

Next