Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hi
I am doing the hand-on part in the core designer certificate. In step 10, what should be the total number of columns? Also, I am able to do aggregate on only 4/7 'descriptive' columns. For some reason, I do not see the 'Avg' aggregate option for those 3 columns. Can you please help?
Thanks
Hi @mahatibharadwaj , without knowing more, it sounds like you do not have the correct storage types for 3 columns. If for example, a column is stored as a string, you wouldn't be able to calculate the Average when grouping. If this is the case, perhaps something went wrong earlier in your Flow (such as the Join).
They are not 'string'. They are 'integer'.
All columns in the original schema after 'join' are 'decimal'. But in this aggregation step, the three computed columns are detected as 'string'. Please help me to rectify this step.
what are the total number of columns in the aggregated dataset?