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

Designing Pipelines
1

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

2

plese help me on that

3

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

image
image1261×297 23.4 KB

BR,
Pero M.

4

Thanks @pmancevski , its working fine.