topic Re: Loading data from a specific date onwards in QlikView

Loading data from a specific date onwards

s10157754 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Loading data from a specific date onwards

Anil_Babu_Samineni — Mon, 18 Dec 2017 02:22:04 GMT

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

Re: Loading data from a specific date onwards

s10157754 — Mon, 18 Dec 2017 02:23:35 GMT

mariusz.kumanski‌

Re: Loading data from a specific date onwards

tamilarasu — Mon, 18 Dec 2017 03:38:41 GMT

Hi QianNing,

Have a look at the attached file.

Re: Loading data from a specific date onwards

s10157754 — Mon, 18 Dec 2017 09:34:18 GMT

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

Re: Loading data from a specific date onwards

tamilarasu — Mon, 18 Dec 2017 09:43:01 GMT

Hi Zhang,

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

Re: Loading data from a specific date onwards

s10157754 — Mon, 18 Dec 2017 10:34:30 GMT

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

Re: Loading data from a specific date onwards

tamilarasu — Mon, 18 Dec 2017 12:22:41 GMT

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

Re: Loading data from a specific date onwards

s10157754 — Mon, 18 Dec 2017 14:15:48 GMT

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

Re: Loading data from a specific date onwards

tamilarasu — Mon, 18 Dec 2017 14:28:11 GMT

Hi QianNing,

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

Re: Loading data from a specific date onwards

s10157754 — Mon, 18 Dec 2017 15:29:32 GMT

Dear Tamil,

I had solved my problem by removing the highlighted one and everything works fine. Thank you so much for your time! Appreciated a lot for your help!

Best Regards,

QianNing

Re: Loading data from a specific date onwards

tamilarasu — Mon, 18 Dec 2017 15:34:37 GMT

Great QianNing!! If you face any issues regarding this, please feel free to reply this thread. Have a fantastic day!!

Re: Loading data from a specific date onwards

s10157754 — Mon, 18 Dec 2017 15:38:52 GMT

Thank you so much Tamil! Have a nice day!