Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
mahnoor1279
Contributor III
Contributor III

How to write sql script in Qliksense editor script

Hello everyone 

 

I want to ask that how can i write the following script into  script editor 

 

SELECT

K.FIRST_NAME, K.AOP_SNO, K._ADDRESS, K.CITY


FROM DIGITAL_ACCT_MAIN M,       DIGITAL_KYC K ,     ACCT_OPENING O
WHERE M.AOP_SNO = K.AOP_SNO
AND O.AOP_SNO = M.AOP_SNO
AND K.RESULT= 'ok'                                                                                                                                                                                                          AND K.VERISYS = 'ok'                                                                                                                                                                                                              AND O.ACCT_REJECT IS NULL
AND TRUNC(M.START_DATE) BETWEEN '01JAN2023' AND '31JAN2023'

AND K.AOP_DIGITAL_KYC_SNO = (SELECT MAX(KYC.DIGITAL_KYC_SNO)
FROM DIGITAL_KYC KYC WHERE KYC.AOP_SNO = M.AOP_SNO);

Labels (4)
2 Replies
Or
MVP
MVP

Exactly as-is. There's no problem with using an SQL query in Data Load Editor.

chriscammers
Partner - Specialist
Partner - Specialist

Don't forget your connection.

When working with databases you need to connect to the database then once you have connected you can use as many sql queries as you like. Then if you want to change connections issue annother connect command and use as many sql commands against that database as you wish

Good luck