topic Re: Exclude values from resident in App Development

Exclude values from resident

YanivZi — Wed, 19 Feb 2025 06:31:41 GMT

I am trying to exclude the math courses equal from Student after using subfield but I got error "StudentsExclude.%Key not exists". what i have done wrong?

Students: LOAD %Key, FirstName, LastName, Courses, Gender, BirthDay RESIDENT FACT StudentsALL: %Key, SubField(Courses, ';') AS Course RESIDENT Students STORE StudentsALL INTO [lib://DEMO/StudentsALL.QVD](qvd); StudentsExclude: LOAD DISTINCT %Key RESIDENT StudentsALL WHERE Course= 'Math'; StudentsExcludeMath: LOAD * RESIDENT Students WHERE NOT Exists(StudentsExclude.%Key); STORE StudentsExcludeMath INTO [lib://DEMO/StudentsExcludeMath.QVD](qvd);

Re: Exclude values from resident

Chanty4u — Wed, 19 Feb 2025 07:28:42 GMT

Change your load script

StudentsExcludeMath:

LOAD *

RESIDENT Students

WHERE NOT Exists(%Key);

Re: Exclude values from resident

marcus_sommer — Wed, 19 Feb 2025 08:46:59 GMT

This: StudentsExclude.%Key indicates that any qualifying is applied. I suggest to remove it completely because it's very seldom an added value (only in specific cases for experienced users) else it will cause a lot of trouble.

Re: Exclude values from resident

Anders_Eriksson — Wed, 19 Feb 2025 14:44:16 GMT

Excluding the qualification will not solve the problem that is asked about.
Sure the script will run but exclude everything since every %Key already exists!
I suggest this;

StudentsExclude: LOAD DISTINCT %Key as %ExcludeKey RESIDENT StudentsALL WHERE Course= 'Math'; StudentsExcludeMath: LOAD * RESIDENT Students WHERE NOT Exists(%ExcludeKey, %Key);