Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can i adjust my load script to ensure the recorded without an AccountId are NOT loaded
Both these expressions kick up errors. What exactly am I doing wrong?
WHERE NOT IsNull(AccountId);
and
WHERE len(trim(AccountId))>0;
You can try
WHERE IsNull(AccountId) = false() OR len(trim(AccountId))>0;
Both on the where.
Try out
Table:
Load *
RESIDENT OtherTable
Where IsNull(AccountId) <> -1
;
Upon testing the:
Where IsNull(AccountID) <> -1
seemed to work for me.
Didn't work. Got the error
"Invalid aggregate function IsNull"
Didn't work. Got the error
"Invalid aggregate function: IsNull"
Hi
Is this criterion in a SQL SELECT statement?
SQL SELECT ......
WHERE len(trim(AccountId))>0;
This does not work because this statement is executed on the database server, not by QV. Translate the statement to the SQL dialect of your server; eg for MS SQLS
SQL SELECT ......
WHERE AccountId IS NOT NULL;
HTH
Jonathan
Can you post entire script
Could you paste your load here?
Regards,
Gabriel
Yeah, as jonathan said, if you are executing this in SQL this will definitely not work.