How to insert the NULL in place of no data in CSV input fields having no data?

[sathishmadavali]

hi team,
the input file having csv data with empty rows in some fields, how to insert the NULL in place of no data in the row.

thanks

[sathishmadavali]

plese help me on that

[pmancevski]

Hi @sathishmadavali,

After CSV parser add mapper and with ternary operator check/map if the field is empty. If it is then add null if not pass the field.
Example:
$fieldName == “” ? null : $fieldName

BR,
Pero M.

[sathishmadavali]

Thanks @pmancevski , its working fine.