Using Load script to update certain values whilst retaining others

[mattphillip]

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

[jmvilaplanap]

Hi

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

Regards

[mattphillip]

Hi Jose,

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

Thanks,

Matt

[jmvilaplanap]

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