"Translation of SQL code to QV

[fabricius]

Can anyone "translate" this SQL code for me into something that I can use in Qlikview?

select distinct WEXAM_ID, WEXAM_ID_STRING, WEXAM_DATE from W_EXAM

left join W_EXAM_FOLDER on WEXAM_ID = WEF_EXAM_ID

left join W_IMAGE_FOLDER on WEF_ID = WIF_EF_ID

where WEF_ID is not null and WIF_ID is null and WEXAM_DATE between '2017-10-01' and '2017-10-31'

group by WEXAM_ID, WEXAM_ID_STRING, WEXAM_DATE, WEF_BF_ID

order by WEXAM_ID_STRING;

[woshua5550]

why you have to do this ? what is your data source ?

[shraddha_g]

you can direcly use this query in qlik

[jonathandienst]

>>something that I can use in Qlikview

That's a little vague. Anyway, it is not necessary to translate the SQL. The SQL query is executed on the database server, not in QV, so you can add the query as-is to your load script with a CONNECT call and your SQL code with a SQL prefix:

CONNECT ....;

TableName:

SQL

SELECT ....;

If you have a reason for "translating" into QV, perhaps you could be a lot more specific about your requirement.