Hello Knime Community,
I have recently started using Knime to create intuitive workflows. I have a question regarding working with CTEs in SQL and how to port that into Knime.
I have given the sample code:
WITH T0 AS (
SELECT b.COMPANY_GUID,b.ORGANIZATION, b.PRIMARY_PROGRAM ,Employee_ID, C.CAL_DATE [START_DATE], D.CAL_DATE [END_DATE], METRIC_NAME, METRIC_VALUE, TIER
FROM PER_FACT_MONTH A
JOIN PER_DIM_EMPLOYEE B
ON A.DIM_EMPLOYEE_ID = B.ID
JOIN PER_DIM_DATE C
ON A.START_DATE_KEY = C.DATE_KEY
JOIN PER_DIM_DATE D
ON A.END_DATE_KEY = D.DATE_KEY
WHERE b.COMPANY_GUID = ‘D2676968-C552-4319-A0F9-22ACF007E441’
AND b.ORGANIZATION = ‘’
AND b.PRIMARY_PROGRAM = '’
AND a.METRIC_NAME IN ( ‘AHT’)–,‘Aux State Accuracy’)
AND a.SUBMETRIC_NAME IS NULL
–ORDER BY METRIC_VALUE
)
, T1 AS (
SELECT b.COMPANY_GUID,b.ORGANIZATION, b.PRIMARY_PROGRAM ,Employee_ID, C.CAL_DATE [START_DATE], D.CAL_DATE [END_DATE], METRIC_NAME, SUBMETRIC_NAME, SUBMETRIC_VALUE
FROM PER_FACT_MONTH A
JOIN PER_DIM_EMPLOYEE B
ON A.DIM_EMPLOYEE_ID = B.ID
JOIN PER_DIM_DATE C
ON A.START_DATE_KEY = C.DATE_KEY
JOIN PER_DIM_DATE D
ON A.END_DATE_KEY = D.DATE_KEY
WHERE b.COMPANY_GUID = ‘D2676968-C552-4319-A0F9-22ACF007E441’
AND b.ORGANIZATION = ‘’
AND b.PRIMARY_PROGRAM = '’
AND a.METRIC_NAME IN ( ‘AHT’)–,‘Aux State Accuracy’)
AND a.SUBMETRIC_NAME IN (‘Calls’)
)
SELECT b.COMPANY_GUID,b.ORGANIZATION, b.PRIMARY_PROGRAM ,b.Employee_ID, b.START_DATE, b.END_DATE, b.METRIC_NAME, b.METRIC_VALUE, b.TIER, c.SUBMETRIC_NAME, c.SUBMETRIC_VALUE
FROM T0 b
INNER JOIN T1 c
ON b.Employee_ID = c.Employee_ID
ORDER BY b.Metric_Value
I need to know how to setup the nodes to get the output of this syntax in knime. I have tried various methods but I am not able to do it.
If someone could help me it would be much appreciated.
Thank you