Working with NULL Values in an ADF Data Flow?

When you are working with ETL/ELT, sometimes you may need to transform NULL into a meaningful value. If you worked with SSIS, you probably know how you handle that. This blog post will describe how do we typically do this in SSIS and then how the very same task can be performed in an ADF Dataflow.

Consider that we have a .csv file where the Name columns have a NULL value for 2nd record (Fig 1). I highlighted the absence of any value in the image.

Fig 1: Sample .csv file with NULL record

After connecting the .csv file