Alteryx Report - Group by function

[jonathanyeo]

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                                           

Issue	Due date
1	3/30/2021
2	4/29/2020
3	7/30/2020

Desired Output                                                                           

	Issue	Due date
Apr-20	2	4/29/2020
Jul-20	3	7/30/2020
Mar-20	1	3/30/2021

Current output

	Issue	Due date
Apr-20	2	4/29/2020
	Issue	Due date
Jul-20	3	7/30/2020
	Issue	Due date
Mar-20	1	3/30/2021

[atcodedog05]

Hi @jonathanyeo ,

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

[atcodedog05 · Accepted solution]

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 · Accepted solution]

Hi @jonathanyeo ,

you want something like that:

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

Best,

Roland 

[atcodedog05 · Accepted solution]

Hi @jonathanyeo ,

Here is a workflow for the scenario.

Outputs:

-Current:

Expected:

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]

Happy to help 🙂 @jonathanyeo 

Cheers and Happy Analysing 😀

[jonathanyeo]

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

[atcodedog05 · Accepted solution]

Hi @jonathanyeo ,

Here is a workflow for the task.

Output:

Will this do. Hope this helps 🙂

[atcodedog05]

@jonathanyeo 

Oh ok cool 🙂👍