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
Solved! Go to Solution.
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:
Hi @Drussek ,
Even if he attaches the data we wont be able to recreate the same scenario since its IN-DB tools.
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.
Hi atcodedog05.
You're right, we won't recreate, but we'd make sure the right tools were used.
@Drussek got to admit. You are right maybe we can give that a try too.
Sorry. I am attaching the workflow here
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.
This is the results after filter
It shows error after I tried to display results from summarize in-db