Disabled options for Summarize tool

Question

I am trying the challenges and faced issue for the Summarize tool options.

The option of 'Sum' is disabled as well as few other options seem to be disabled.

Not sure if this is because of data/current Alteryx version.

Attached screenshot for reference.

Issue screenshot.png

Saurabh_ghumare · Accepted Answer

@aatalai : thanks for suggestion

I checked and it is in number format.

To be specific I am trying to work on Challenge #222: Where There's a Whale There's a Way.

I referred to the solution after lot of tries and found that options are disabled.

I ran the solution file from site and it works fine.

Surprisingly , if I copy and past the Summarize from Solution file to my current file, it works fine.

But, It does not enable the option for me if i drag new summarize tool and try to select the Sum option.

Jonathan-Sherman · Accepted Answer

@Saurabh_ghumareI agree with @aatalai. This is caused by data types, it might appear as though your number is numeric but the data type determines how the value is stored. Currently it's stored as a v_string which is non-numeric and therefore you will not be able to perform any numeric operations (such as summing) on the column. You'll need to use a select tool before the summarise to change the data type to a float or double.

Kind regards,

Jonathan

Saurabh_ghumare · Accepted Answer

Agreed. It was miss from my side on the data type.

I did data type change in the Join tool before using summarize tool.

This has solved the problem.

Thanks