We had one requirement to map users manager with email id field provided while doing flatfile import .
Using below preprocessor JSON it is working :
UPDATE NEWUSERDATA SET NEWUSERDATA.MANAGER=(select CURRENTUSERS.USERNAME from CURRENTUSERS where CURRENTUSERS.EMAIL=NEWUSERDATA.MANAGER)
Need to understand why it is so ?
SET MANAGER=CURRENTUSERS.USERKEY ( not working )
SET MANAGER= CURRENTUSERS.USERNAME (working)
From the user table we can see manager field holds only integer (i.e. userkey value) then ideally first logic should have worked . But it is not working . Please suggest .