Alteryx Reporting Merging Cells

[jaimonsk]

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

Expected Output

Thanks in advance :)

[TrevorS]

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

[danilang · Accepted solution]

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.

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

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

Dan