Hi,
Could you please help how we can convert following SQL script into Qlik:
this is in sql
DECLARE @COLS NVARCHAR(MAX)
SELECT @COLS = COALESCE(@COLS + ',[' + CFNAME + ']',
'[' + CFNAME + ']')
FROM CUSTOMFIELD
WHERE CFNAME NOT IN ('Time in Status', 'ToolBar')
GROUP BY CFNAME
------------------------------------------------
JOIN
(SELECT T2.ISSUE ISSUEID
, T1.CFNAME
, (CASE
WHEN [STRINGVALUE] IS NOT NULL
THEN CAST ([STRINGVALUE] AS NVARCHAR(1024))
WHEN [DATEVALUE] IS NOT NULL
THEN CAST ([DATEVALUE] AS NVARCHAR(1024))
WHEN [NUMBERVALUE] IS NOT NULL
THEN CAST ([NUMBERVALUE] AS NVARCHAR(1024))
WHEN [TEXTVALUE] IS NOT NULL
THEN CAST ([TEXTVALUE] AS NVARCHAR(4000))
ELSE '' ''
END) VALUE
FROM CUSTOMFIELD AS T1
JOIN CUSTOMFIELDVALUE AS T2 ON T1.ID = T2.CUSTOMFIELD) P
PIVOT
(
MAX([VALUE])
FOR CFNAME IN
( '+@COLS +' ) -- this is declared on top
) AS PVT
ON JIRAISSUE.ID = PVT.ISSUEID;'
----------------------------------------------------------------------
2., ISNULL(CAST (JIRAISSUE.REPORTER AS NVARCHAR(4000)), '' '') REPORTER
Thanks,
---------------------------------------