Summarize IN-DB does not work

[Haotian]

Hi Community.

I am a newbie for Alteryx. I am trying to use Summarize in-db to group by string and count distinct other variables. But it will not give me any error message and results. There are no results to show up. 

Now I am confused and need help.

Thanks

Haotian

[Haotian]

Yes, Count distinct can not work regardless of renaming or not. 

A following up question: Can I use an in-db tool to change type of a column, such as converting numerical to string?

[atcodedog05]

Hi @Haotian 

You say it worked i can give you a breakdown on my approach.

[atcodedog05]

oh ok ok

[Haotian]

Thank you for the help. Count without distinct or sum can work well.

[atcodedog05 · Accepted solution]

Hi @Haotian 

Answer on your follow up question.

The answer is no since its linked with the SQL database. You cannot change datatype of the existing column.

But if you are importing data to the Alteryx using Data stream in or directly load the data using Input tool.

You can change data type for manipulation.

[Haotian]

Perfect. Thank you so much for the help.

[atcodedog05]

Happy to help : ) @Haotian 

Cheers and Happy analyzing : )