This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 53%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
87419-adf-transformaion-issue.pdf
In Derived column transformation am trying split data based on Gender but on split condition when am trying to write expression it is not showing any input columns currently you can see same thing in the following attachments .
An Azure service for ingesting, preparing, and transforming data at scale.
Whenever you see the "drifted" icon next to the column name and type in the preview data header, it means that you have not imported the schema and you have no projection. In this mode, you would have to use column patterns to work with your data. Otherwise, go back to the Source transformation Projection tab and import the schema.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 44%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Hi @RaviTutika ,
Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.
Thanks
Saurabh
Hi @RaviTutika ,
From the screenshot you provided, it seems like schema is missing. I think, if you import the schema in the Excel Dataset, the issue will solve. Thanks!
Regards
Nasreen
Hi @RaviTutika ,
Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.
Thanks
Saurabh