Home > Net >  Azure Data Flow Aggregate transformation not showing columns in groupby dropdown
Azure Data Flow Aggregate transformation not showing columns in groupby dropdown

Time:12-31

In the following enter image description here

Snapshot of Preview data of Source: Employee

enter image description here

CodePudding user response:

You need to cross check your dataset schema in Dataset settings, in Source Projection and make sure that schema is imported.

In your Dataset, make sure you have check marked First row as header option under Connection Tab. This will make first row as Column names when dataset is .csv file.

enter image description here

Then, under Schema Tab, follow Import Schema -> From connection/store. This will show your first row as column names. Refer below image.

enter image description here

Now, in your Data flow, under Source Projection settings, it must be showing the column names. If not, follow Projection -> Import projection to import the schema from dataset settings. Follow below image.

enter image description here

Finally, after all these settings, you will be able to see column names under Aggregate settings as shown below.

enter image description here

  • Related