11-18-2022 06:19 AM
having difficult time to do a condition on an update into PREPROCESSQUERIES
I've add the TER'DATE into the AdditionalTables then in my PREPROCESSQUERIES I have
"UPDATE NEWUSERDATA SET STATUSKEY = CASE WHEN CUSTOMPROPERTY1='Active' AND TERMDATE IS NULL THEN '1' ELSE '0' END"
When launching the job, it tell me Error - to Import Data correctly: Error in Users
Import - Error while processing data: Unknown
column 'TERMDATE' in 'field list'
That can cause that? Did I have the good field name? in Dataanalyser is good!
thanks for the help
Solved! Go to Solution.
11-18-2022 09:37 AM
"UPDATE NEWUSERDATA SET NEWUSERDATA.STATUSKEY = CASE WHEN NEWUSERDATA.CUSTOMPROPERTY1='Active' AND NEWUSERDATA.TERMDATE IS NULL THEN '1' ELSE '0' END"
You need to join CURRENTUSERTDATA
11-18-2022 12:36 PM
Not sure why the previous without TERMDATE using only CUSTOMPROPERTY1 in the Case statement was working then.