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

[atcodedog05]

Hi @Haotian ,

Did you check your data with browse and i am guessing your using In-Db summarize.

[Drussek]

Hi Haotian

Maybe you should attache your flow? It's hard to figure out what the reason may be.
This is my working solution with MS SQL db:

[atcodedog05]

Hi @Drussek ,

Even if he attaches the data we wont be able to recreate the same scenario since its IN-DB tools.

[atcodedog05]

Hi @Haotian ,

Try a grouby sql query in your DBMS tool. If it works this should also work. 

In-DB tools are just creating sql queries in an optimized way.

[Drussek]

Hi atcodedog05.

You're right, we won't recreate, but we'd make sure the right tools were used.

[atcodedog05]

@Drussek  got to admit. You are right maybe we can give that a try too.

[Haotian]

Sorry. I am attaching the workflow here

[atcodedog05]

Hi @Haotian ,

Use the IN-DB browse and check the output after Filter tool.

And also use IN-DB browse after Summarize and show us the output.

[Haotian]

This is the results after filter 

It shows error after I tried to display results from summarize in-db