What is difference between keep and exist()?

[mastankomatla21]

Hi Team,

What is difference between keep and exist()?

Regards,

Masthan

[YoussefBelloum]

Hi,

all the info you need is here:

Exist()

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

Keep()

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

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