Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Summarize IN-DB does not work

Haotian
6 - Meteoroid

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

26 REPLIES 26
atcodedog05
22 - Nova
22 - Nova

Hi @Haotian ,

 

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

Drussek
9 - Comet

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:

Drussek_0-1601484101294.png

 

atcodedog05
22 - Nova
22 - Nova

Hi @Drussek ,

 

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

atcodedog05
22 - Nova
22 - Nova

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
9 - Comet

Hi atcodedog05.

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

atcodedog05
22 - Nova
22 - Nova

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

Haotian
6 - Meteoroid

Sorry. I am attaching the workflow here

 

Haotian_0-1601485100294.png

 

atcodedog05
22 - Nova
22 - Nova

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
6 - Meteoroid

This is the results after filter 

Haotian_1-1601485712335.png

 

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

 

Haotian_2-1601485777927.png

 

 

Labels
Top Solution Authors