Use CASE statement in Fastload script

UDA

Use CASE statement in Fastload script

Hi All,

Can we use CASE statement in a fastload script. I want to check for zero length string. Is it possible to use some thing like this

CASE(LENGTH(:input_string)=0) Then 'UNKNOWN' Else :input_string

Please advise.

Thanks,
Amit
1 REPLY
Enthusiast

Re: Use CASE statement in Fastload script

You can't use case statement directly in the fastload script.
It is possbile for you to embed INMOD into fastload to do such transfer job.

Or you can use NULLIF in the define section.
But with this method, the input field containing the specified value should be treated as NULL...