I have a blended dataset, it checks if field New Comment and Office Comments are present in one dataset and matches them to another dataset. I'm creating a dynamic link that checks if New Comment and Office Comment are present, if they all are - it generates a url for the user - if there are blanks - I want to generate a blank URL. I can't seem to get it to work, the code generates both links (when looking at the underlying data) This is the code. Any ideas why it doesn't work?
CASE
WHEN (New Comment IS NULL OR TRIM(New Comment) = '') OR (Office Comments IS NULL OR TRIM(Office Comments) = '') THEN NULL
ELSE CONCAT(
"https://xxxxxxx=",
CAST(EXTRACT(MONTH FROM DATETIME_TRUNC(Start Date (Table 2), ISOWEEK)) AS STRING),
"&weekCommencing[day]=",
CAST(EXTRACT(DAY FROM DATETIME_TRUNC(Start Date (Table 2), ISOWEEK)) AS STRING),
"&weekCommencing[year]=",
CAST(EXTRACT(YEAR FROM DATETIME_TRUNC(Start Date (Table 2), ISOWEEK)) AS STRING),
"&name67=",
Calendar Name
)
END
LinkedIn
Twitter
