Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a bunch of files that I need to load on a daily basis. This isn't a problem, as they are all basically the same, bar the ending.
My question is, how can I remove the digits on the end so QlikView will load the file and I don't have to keep changing the numbers each day?
Here's an example of the file name, the numbers in bold being the bit I need to remove!
MI_029_ADT_LDM_Due_280119.csv
Thanks
Di
load MI_029_ADT_LDM_Due*.csv
or
load MI_029_ADT_LDM_Due_??????.csv if you want 6 characters and not more
load MI_029_ADT_LDM_Due*.csv
or
load MI_029_ADT_LDM_Due_??????.csv if you want 6 characters and not more
Doh!
That easy?!
I'll give it a go!
Thanks!