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

Alteryx Report - Group by function

jonathanyeo
6 - Meteoroid

Hi i hope to get some help with the Report -> Table -> group-by function

 

I have unique items with due dates in my raw data. I have a formula to trim the dates to the start of the month, and in the table tool I have grouped these items up by the group-by function. 

 

How do I only include the first row of columns in my output? Right now it is duplicating all columns for every group, which looks a bit messy.  

 

Raw data, desired out put and current output is pasted below. 

 

Raw data                                           

IssueDue date
13/30/2021
24/29/2020
37/30/2020
  

 

Desired Output                                                                           

 IssueDue date
Apr-2024/29/2020
Jul-2037/30/2020
Mar-2013/30/2021

 

Current output

 IssueDue date
Apr-2024/29/2020
 IssueDue date
Jul-2037/30/2020
 IssueDue date
Mar-2013/30/2021
8 REPLIES 8
atcodedog05
22 - Nova
22 - Nova

Hi @jonathanyeo ,

 

Can you provide your workflow. It will very helpful to troubleshoot and fix it.

atcodedog05
22 - Nova
22 - Nova

Hi @jonathanyeo ,

 

I guess you are using Groupby in Table tool. Hence you are getting this output.

 

To get your desired output do groupby in a summarize and load it to Table tool. Dont use any Groupby in table tool.

RolandSchubert
16 - Nebula
16 - Nebula

Hi @jonathanyeo ,

 

you want something like that:

2020-10-05_11-31-58.png

I've attached a sample workflow. Let me know if it works for you

 

Best,

 

Roland 

atcodedog05
22 - Nova
22 - Nova

Hi @jonathanyeo ,

 

Here is a workflow for the scenario.

atcodedog05_0-1601890449005.png

Outputs:

-Current:

atcodedog05_1-1601890493190.png

Expected:

atcodedog05_2-1601890510609.png

 

I hope i am nearby to the solution.

 

Hope this helps 🙂

 

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

 

atcodedog05
22 - Nova
22 - Nova

Happy to help 🙂 @jonathanyeo 

 

Cheers and Happy Analysing 😀

jonathanyeo
6 - Meteoroid

Edit: Nevermind, got it to work, thanks both!

 

 

atcodedog05
22 - Nova
22 - Nova

Hi @jonathanyeo ,

 

Here is a workflow for the task.

 

Output:

atcodedog05_0-1601891790218.png

Will this do. Hope this helps 🙂

atcodedog05
22 - Nova
22 - Nova

@jonathanyeo 

 

Oh ok cool 🙂👍

Labels
Top Solution Authors