topic Re: Replacing default value to user defined value in Qlik Replicate

Replacing default value to user defined value

suvbin — Sat, 16 Nov 2024 00:33:36 GMT

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.

Re: Replacing default value to user defined value

AlexeySosnovskih — Tue, 02 Jun 2020 15:57:52 GMT

replace($name,'00000000',strftime('%Y/%m/%d','now'))

Re: Replacing default value to user defined value

suvbin — Tue, 02 Jun 2020 16:08:22 GMT

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 ?

Re: Replacing default value to user defined value

Madhavi_Konda — Tue, 02 Jun 2020 16:10:58 GMT

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

Re: Replacing default value to user defined value

suvbin — Tue, 02 Jun 2020 16:17:58 GMT

Ok for each column i need to open expression builder seperately and then give this transformation.

Re: Replacing default value to user defined value

Madhavi_Konda — Tue, 02 Jun 2020 16:38:44 GMT

Yes.

Re: Replacing default value to user defined value

suvbin — Tue, 02 Jun 2020 17:42:54 GMT

Thank you Alexey , Thank you Madhavi.