community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More
SOLVED

Alteryx Reporting Merging Cells

Highlighted
Meteor

Hello experts,

 

I've been trying to create an automated  word report for an analysis. Here I encountered a situation similar to this.I would like to merge cells from 3-7 and map it as shown the expected output screenshot

What i currently have

image.png

 

 

 

 

 

 

 

 

 

 

 

Expected Output

image.png

 

 

 

 

 

 

 

 

 

 

 

Thanks in advance :)

Moderator
Moderator

Hello @jaimonsk ,

 

I am not sure if this is exactly what you are looking for, but this post goes over merging cells with the table tool.

I would recommend starting there and see if this gets you started down the right path.


If you are still struggling, could you upload some sample data, as well as your workflow so far? This will help our Community to troubleshoot further.

 

Thanks!

TrevorS

Aurora

Hi @jaimonsk 

 

@TrevorS has a good solution but it deals more with merged columns.  Your requirement is for merged rows.  You can do this without using  the reporting tools.

 

WF.png

 

The first Multi-Row tool builds up the merged text by adding a newline character ASC(10) between the current text and the text form the line above, based on the "Not Mapped" value in field 2.  The second one adds a new boolean field that determines if we want to keep this row in the output.  The T output of the filter only passes rows where "KeepRow" = true.  The final output in Excel looks like this

 

Excel.png

 

The newlines will carry over through the reporting tools to the word document as well.

 

 

Dan

 

Labels