Forum Discussion

sathishmadavali's avatar
sathishmadavali
New Contributor II
3 years ago

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

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
winosky's avatar
winosky
New Contributor III
5 years ago
Copy Link

Hi @fmdf, depending on the destination if it’s another db usually it could take care of it without the conversion but if it’s to excel then I would try using an execute snap and converting it within the execute snap or if that’s not an option maybe look into the match data type option in the select snap maybe.

  • bojanvelevski's avatar
    bojanvelevski
    Valued Contributor
    4 years ago
    Copy Link

    Hey @nagh,

    I believe you have a very similar, if not the same post from several days ago. I sent you a pipeline there that converts base64 to hex, is that what you need?

    Link to post:
    Base64 to hexadecimal