Table data with Chinese text and Table values.

[AbhijeetChib]

I have an Alteryx workflow where I am using some Chinese text and a table. I am using the formula tool to define sections of Chinese text and passing them to a table. The table consists of 3 sections of Chinese text and 1 section of table data and then I union them together and then pass to a layout tool. I group all of them by the fields email and requisitioner.

When I pass them to the layout tool I get repetitive sections with the number of table rows. Each section repeats itself by the number of rows in the data table.
When I union text sections with a table and then group by fields like email and requisitioner, Alteryx duplicates the text sections for each row in the table because the grouping causes each row to be treated as a separate group.
How do I ensure that the text sections appear only once per group, not once per row.

Below is the section of the union. 

I would most definitely appreciate any suggestion here. 

[binuacs]

@AbhijeetChib can you provide sample input data and expected output for better understanding?

[AbhijeetChib]

hi @binuacs 

Here is how the email structure is, and this works if the number of record in the table is 1

Section -1 - "Hi Chinese text here" is defined in a formula tool and passed to a table. 

Section 2 - " More Chinese text" is defined in another formula tool and passed to table. 

Same with others. The issue starts to happen if there are more than 1 records - which are grouped by 2 fields email and unique ID. The  static text just repeats like this

[AbhijeetChib]

[AbhijeetChib]

The table is fine, no issues there. Its just that the static text is repeating every ROW instead of repeating every group. 

[AbhijeetChib]

@binuacs I am not using the Report text tool as it messes up the Chinese letters totally. Passing it in sections of text works but the repetition becomes an issue and explained above. 

[AbhijeetChib]

Expected output

Hi Chinese text here 

More chinese text

some more

[binuacs]

@AbhijeetChib attaching a sample workflow, i guess you are getting only one email id for all records, if not let me know