What is difference between keep and exist()?

Hi,

all the info you need is here:

Exist()

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/InterRecordFunctions/Exists.htm

Keep()

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptPrefixes/Keep.htm

exist is used to look at loaded values on a field to filter a load for example

Keep is used on data modeling to replace joins type sometimes, to keep the tables separate