Column is always getting null values in adf data flows when using Common Data Model Inline Dataset as source

Amar Agnihotri 891 Reputation points
2022-07-26T14:10:57.817+00:00

Hi ,
I have created a dataflow in adf which is using CDM Inline dataset and model.json file for column mapping and just creating a csv file . This is my dataflow
224893-image.png

It is using model.json file for the column mapping
224904-image.png

This is my source file which will be copied as a .csv file . Her you can see that it is having only data but no column names. You can see that it is having created dates

224818-image.png

and this is the model.json file which is having all the columns of the above data

224849-image.png

Now my dataflow is grabbing all the data from the source file and mapping all the columns using model.json file

224850-image.png
These are the settings of the dataflow
224819-image.png
224921-image.png

But in the data preview see the values inside created are coming NULL
224870-image.png

This is my sink settings in dataflow
224894-image.png
224875-image.png
224820-image.png
224913-image.png
224941-image.png
224914-image.png
224951-image.png
Why it is not pulling the data for created column and giving null values there. ?Where am i doing wrong ? Please suggest something to get it done .

Thanks

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,080 questions
{count} vote

1 answer

Sort by: Most helpful
  1. Amar Agnihotri 891 Reputation points
    2022-07-27T11:45:37.1+00:00

    @MartinJaffer-MSFT

    Thanks for the reply . This is my dataflowscript
    225275-cdm-script.png

    and i changed datatype to string
    225264-image.png

    but still getting null values in date column
    225276-image.png

    I also checked this import schema option but no ways..