Merging Title

[HongS]

Could you share how I can merge title, date and month will change accordingly. I've used Report Text, Basic Table and Render tool.

Desired Output

Current Output

So, it stops at Column A unless desired output title is merging to column A 

Thanks.

[Linas]

Hi @HongS , you can learn how to merge cells here:

https://community.alteryx.com/t5/Engine-Works/How-to-Create-Merged-Cells-in-Reports-Part-1/ba-p/9746...

https://community.alteryx.com/t5/Engine-Works/How-to-Create-Merged-Cells-in-Reports-Part-2/ba-p/9787...

https://community.alteryx.com/t5/Engine-Works/How-to-Create-Merged-Cells-in-Reports-Part-3/ba-p/9813...

[ShankerV]

Hi @HongS 

Please find the desired output.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[HongS]

Hi @Shanker

Thanks. How to change ddmmyyyy highlighted in red ?

[ShankerV]

Hi @HongS 

We will not able to highlight only partial text in another color in Table tool. If you need to highlight only partial text then you need add one more formula tool to get the partial text coloring done.

In basic table tool only whole text can be formatted to another color.

Many thanks

Shanker V

[HongS]

Hi Shanker,

Thanks. ddmmyyyy will change based on the date data is run. In this case AB23112022 will change to AB21122022. Similarly ngay 21 thang 12 nam 2022