Alteryx Report - Group by function

Question

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 date13/30/202124/29/202037/30/2020

Desired Output

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

Current output

IssueDue dateApr-2024/29/2020 IssueDue dateJul-2037/30/2020 IssueDue dateMar-2013/30/2021

atcodedog05 · Accepted Answer

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 Answer

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 Answer

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 · Accepted Answer

Hi @jonathanyeo ,

Here is a workflow for the task.

Output:

Will this do. Hope this helps 🙂