How to insert Space to replace Null by Reformat

CloverDX Platform
1

Hi,

I would like to transform data from Input table to Output table, fields type of Output table is Not Null.
I have an question about how am I replace null by space if the field is null by use Reformat. For example data as in the attached file. Please give me the guideline how to use reformat to transform it.

Thank you.

2

Hi Jean,

I would use something like this:

if (isnull($in.0.A)) {$out.0.A = " ";}
if (isnull($in.0.B)) {$out.0.B = " ";}
if (isnull($in.0.C)) {$out.0.C = " ";}
if (isnull($in.0.D)) {$out.0.D = " ";}
if (isnull($in.0.E)) {$out.0.E = " ";}

OR

$out.0.A = nvl($in.0.A, " ");
$out.0.B = nvl($in.0.B, " ");
$out.0.C = nvl($in.0.C, " ");
$out.0.D = nvl($in.0.D, " ");
$out.0.E = nvl($in.0.E, " ");

Does it meet your requirement?

Kind regards,

3

Hi Imriskal,

Yes, it is work in the second solution. Thanks.