![]() Inner join dim_patient dpat with (nolock) on fis.DIM_PATIENT_ID = dpat.DIM_PATIENT_ID Inner join IPA on fis.IP_SPELL_EXTERNAL_ID = IPA.SourceValue Ipa.TerminalLoc as 'Adm Tim.Terminal Location' Ipa.SystemUser as 'Adm Tim.Admission end User', (DATEDIFF(SECOND, fis.ADMIT_DTTM, ipa.CreateDate)/3600.0) as 'Adm Tim.Timeliness (hrs)', ![]() Ipa.CreateDate as 'Adm Tim.Date/time Admission logged', Ssu.SSU_NAME as 'Adm Tim.Admitting Ward',įis.ADMIT_DTTM as 'Adm Tim.Date/time Admission', Ssu.SSU_MAIN_CODE as 'Adm Tim.Admitting Ward Code', Where faf.LOG_DTTM between and datc.DIM_AUDIT_TRANSACTION_COMMAND_ID in('21481','21851') On faf.DIM_SYSTEM_USER_ID = dsu.DIM_SYSTEM_USER_ID Inner join DIM_SYSTEM_USER as dsu with (nolock) On faf.DIM_SYSTEM_TERMINAL_ID = st.DIM_SYSTEM_TERM_ID Inner Join DIM_SYSTEM_TERMINAL as st with (nolock) ![]() On faf.DIM_AUDIT_TRANSACTION_COMMAND_ID = datc.DIM_AUDIT_TRANSACTION_COMMAND_ID Inner join DIM_AUDIT_TRANSACTION_COMMAND as datc with (nolock) INSERT INTO SUBSTRING(FAF.SOURCE_VALUE,2,36), I'm also aware it will probably involve using Qlik's 'LET' function. The script below gives me an error message which I believe is caused by my DECLARE parameters. I'm having trouble getting my head around how to integrate DECLARE statements (in the SQL sense of setting variables, temporary tables etc) into my Qlik Sense Load script.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |