Loading data from a specific date onwards

[s10157754]

Dear Qlikview Experts,

Sometimes there are old data we do not wish to load, is it possible for the user to choose and load the data from a specific date? Maybe by changing the code in script but I am not good at scripting.

I had attached my current script and sample below for your reference. For example, I would only like to load the text files with date from 15th_Dec_2017 onwards, how can I achieve this by modifying the code? Any suggestions from you all would be greatly appreciated!

Best Regards,

QianNing

[Anil_Babu_Samineni]

May be https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/

[s10157754]

mariusz.kumanski‌

[tamilarasu · Accepted solution]

Hi QianNing,

Have a look at the attached file.

[s10157754]

Dear Nagaraj,

Are you able to teach me on how to modify the code if I want to load my data from 01st_Dec_2017 onwards? Thanks a lot in advance!

Best Regards

QianNing

[tamilarasu]

Hi Zhang,

Sure.   You can change this line in edit script. Kindly let me know if you need any further information.

[s10157754]

Dear Tamil,

Thanks for your prompt reply. But it can only load the data with a date end with ‘th’. You can refer to my Zip File. There are text files starting with ‘01st_Dec_2017’ and ‘02nd_Dec_2017’. How to include these files as well? Thanks so much for your help!

Best Regards

QianNing

[tamilarasu]

My bad. Sorry. Please find the updated script from below text file. If you still have any issues, let me know.

[s10157754]

Dear Tamil,

Thanks for your concern. I have been trying your code for like half an hour. But I still cannot figure out what went wrong. I keep getting the following error after inserting your code to my script.

Best Regards

QianNing

[tamilarasu]

Hi QianNing,

The issue is not with the script that I have provided. The below highlighted file is not available in the mentioned path.