Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to replace the default value 00000000 to some date value like 01/02/2020. I have few date columns, in the source side the default value is kept as 0000000 to them. if i want to change the the default value to some date value, then how to do it using expression builder.
replace($name,'00000000',strftime('%Y/%m/%d','now'))
case when $DATE_TEST='00000000' then '01/01/2020' else $DATE_TEST end you can use this expression as well.
And also as Alexey suggested replace($DATE_TEST,'00000000','01/01/2020')
Thanks,
Madhavi
replace($name,'00000000',strftime('%Y/%m/%d','now'))
Thank you for the update. if i want to put only this value "01/02/1900" then ... ? And also if i want to replace more than on e column ... ? how to do that
replace($name,'00000000',strftime('%Y/%m/%d','now')) -- > this will replace with the current date ?
case when $DATE_TEST='00000000' then '01/01/2020' else $DATE_TEST end you can use this expression as well.
And also as Alexey suggested replace($DATE_TEST,'00000000','01/01/2020')
Thanks,
Madhavi
Ok for each column i need to open expression builder seperately and then give this transformation.
Yes.
Thank you Alexey , Thank you Madhavi.