How 'Treat empty column as null feature' can be implemented in ADLS gen2 dataset in Azure Data Factory?

Suman Dutta 1 Reputation point
2022-04-28T06:51:12.173+00:00

There is a feature as 'Treat empty column as null' in ADLS gen1 dataset. We are migrating ADLS gen1 to gen2 . In the ADLS gen2 dataset this property is not there. How can we implement this property in ADLS gen2 dataset? Also, what does this property does? I have attached as snapshot of this property in aDLS gen1 dataset..
197140-image.png

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,424 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,129 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Pratik Somaiya 4,206 Reputation points
    2022-04-28T09:57:43.177+00:00

    Hello @Suman Dutta

    You can use Azure Data Flow to apply the transformation as mentioned in this link

    ADLS Gen 2 Dataset only have the following Dataset properties:

    197297-image.png