Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Table Design Changes

sanchit089
5 - Atom

I am working to redesigning a table structure to put it into reports in a particular format. I have a table as given below, and for each group of Brand I want to calculate the total price sold for the brand. I can do the total part, where I can use the summarize tool with the union to have the aggregated rows merged between the data. What I am really stuck at is the part where I need to show the brand name at the top of each brand group(brand name is shown on top of each brand group). Also, the brand name group text is 1 complete cell in the entire row. 

 

I would appreciate if someone could help me with this. 

 

Input Table:

BrandProductDatePurchasePrice
NikeT-shirt2020-08-1413.99
NikeCap2020-08-149.99
AdidasTshirt2020-08-1415.99
AdidasShorts2020-08-1420.99

 

Output Table:

sanchit089_0-1597446333162.png

 

3 REPLIES 3
DavidP
17 - Castor
17 - Castor

The output data tool can't do merged columns. The only way really is with Reporting tools.

 

Have a look at the workflow attached

 

DavidP_0-1597478888311.png

 

DavidP
17 - Castor
17 - Castor

Sorry @sanchit089, I was in a bit of a rush this morning. Here is the same workflow with documentation to show what every bit does. I've added a little bit of formatting too, to the header color using default table settings in the header table tool, and the merged cell background color in the Text Tool.

 

Let me know if you have any questions

 

DavidP_0-1597526638544.png

 

sanchit089
5 - Atom

Thanks, @

Labels