Below load script work fine :-
COY_NAME as KeyAcc_CoyName
IF(EXISTS(KeyAcc_CoyName,COY_NAME), 'Y', 'N') as flag_key_acc // need to modify this load script
DROP FIELD KeyAcc_CoyName;
Below is the result i get :-
May i know how to make the "-" display as Y ? and Y display as N or -
Thank you for your sharing .
May i know can you explain to you how you able to logic out ? So that i am able to understand. As this need to be able to analyse 3 step ahead.
Hello Paul, the code was looking for values in table ZOHO that already existed in table VTIGER, but if the value didn't existed in ZOHO table it was not checked.
First I'm creating a temporal table that concatenates the values of ZOHO and VTIGER, so this table that has all keys to check which ones already existed in VTIGER, this is the tmpZOHO table. It has the full ZOHO table and concatenates the values of VTIGER that doesn't exists in ZOHO using "chkCOY_NAME" field and "where not Exists(chkCOY_NAME, COY_NAME)" clause.
I try to apply your script to my actual application , now i get stuck , hope you can advise me.