topic Re: load files with certain ending in QlikView

load files with certain ending

yelin_nyu — Sat, 28 Dec 2013 01:22:22 GMT

the file name is xxxyyyyzzzz_date1_date2.qvd

date 2 is always a Friday, so I know for sure what's goning to be. but date 1 is ambiguous. it could be any date.

so I want load files with given date2.

tried xxxyyyyzzzz_*_date2.qvd and few other approach.

* seems only work when it's placed at last not in the middle. how do I insert a sign to take whatever that's in the middle, as long as it begins w given format and end w given date2?

help please

Re: load files with certain ending

Gysbert_Wassenaar — Sat, 28 Dec 2013 08:18:06 GMT

I can't reproduce this. The wildcard in the middle works fine for me. Can you post an example with sample qvd files that demonstrates the problem?

Re: load files with certain ending

yelin_nyu — Sat, 28 Dec 2013 18:28:39 GMT

my bad, had a & in there by accident. the file name was pretty long, my eyes must missed it. thanks for your help