topic Re: Using Load script to update certain values whilst retaining others in QlikView

Using Load script to update certain values whilst retaining others

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

Hoping someone might be able to help. I have a field within my dashboard containing previous institutions. As some of them have now changed name, I would like to add some code to the load script to update those institutions whose names have changed whilst retaining those who have not changed their names.

Does anyone know how to approach this?

Thanks,

Matt

Re: Using Load script to update certain values whilst retaining others

jmvilaplanap — Thu, 20 Jul 2017 09:10:03 GMT

You can load your previous QVD and then load the datasource using "WHERE NOT EXIST (institutionName)"

Regards

Re: Using Load script to update certain values whilst retaining others

mattphillip — Thu, 20 Jul 2017 09:32:57 GMT

Hi Jose,

Would this replace the outdated names in the field or would it simply add the new names to the field?

Thanks,

Matt

Re: Using Load script to update certain values whilst retaining others

jmvilaplanap — Thu, 20 Jul 2017 09:48:32 GMT

This is only for add new names to the field

But here you have a great post explaining the different incremental loading ways

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

Regards