This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 30%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN9%3C/text%3E%3C/svg%3E)
I would like to reproduce the following CASE statement in a SYNAPSE data flow.
CASE
WHEN A = '00000000'
THEN NULL
ELSE TO_DATE(A, 'YYYYMMDD')
END AS "release_date"
I would like to know how to do it, whether it is a conditional branch of the data flow or a derived column.
Thank you in advance.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 12%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Just checking if the below answer helped or else please let us know for any blockers, so that we can assist
Just checking again to see if you still have any question reg this or the below answer helped.
In case the below answer helped, request you to mark it as answer.
thank you
You can use a derived column transformation, and use either iif() or case().
Reference: MS
Similar thread: Here
Video Reference: yd511kgV78U
Please let us know if it helps.
Thanks