Snapshot of Preview data of Source: Employee
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.
Then, under Schema Tab, follow Import Schema -> From connection/store. This will show your first row as column names. Refer below image.
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.
Finally, after all these settings, you will be able to see column names under Aggregate settings as shown below.