nam
nam

Reputation: 23769

Azure Data Flow Aggregate transformation not showing columns in groupby dropdown

In the following Azure Data Flow, the Employee source is an employee.csv file. And I need to groupby DEPARTMENT_ID of employee.csv. But the BroupBy dropdown (shown below) is not showing any columns to choose from. However, the source's Preview Data button does show the data from the employee.csv file.

Question: Why the BroupBy dropdown not showing any column, and can we fix the issue?

Data Flow:

enter image description here

Snapshot of Preview data of Source: Employee

enter image description here

Upvotes: 0

Views: 1267

Answers (1)

Utkarsh Pal
Utkarsh Pal

Reputation: 4544

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

Upvotes: 3

Related Questions