Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Friends ,
I am trying to reload my data in qliksense cloud where I have some SQL subqueries in my script and in this some WHERE commands are not working even am not getting any syntax error
where FD.FILE_NO = C.FILE_NO
AND c.policy_type in ('CP_PLUS')
and C.POLICY_STATUS IN ('COI_EMAIL','COI_RCVD','COI_RECD','DISB_MADE','DOWNLOAD')
AND FD.ACTUAL_DATE between to_char((trunc((sysdate),'month')),'DD-MON-YYYY') and to_char(trunc(last_day(sysdate)),'DD-MON-YYYY');
Exit SCRIPT;
This part may not work like expected:
... to_char((trunc((sysdate),'month')),'DD-MON-YYYY') and
to_char(trunc(last_day(sysdate)),'DD-MON-YYYY') ...
Therefore I suggest you remove it from the where clause and adds them entirely and also partly as fields to see how your transformations are working.
- Marcus
Yeah, Its working now Thank you Marcus