Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Loading files - Removing bits!

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

 

1 Solution

Accepted Solutions
Anonymous
Not applicable

load MI_029_ADT_LDM_Due*.csv

or

load MI_029_ADT_LDM_Due_??????.csv if you want 6 characters and not more

View solution in original post

2 Replies
Anonymous
Not applicable

load MI_029_ADT_LDM_Due*.csv

or

load MI_029_ADT_LDM_Due_??????.csv if you want 6 characters and not more

View solution in original post

Creator II
Creator II

Doh!

That easy?!

I'll give it a go!

Thanks!