Unable to print New Lines by using "\n" in Table Transformer SQL query

vinay singh_q1e5f8

Hi All ,

 

I am using the Table transformer Macro wheer I am concatenating two string columns .

and I need 2 empty lines between the two concatenated strings .

I have tried using

select str1 + "\n\n" + str2 from T1 

but the above sql query is displaying any new lines in the confluence page.

 

Thanks in advance

Katerina Kovriga {Stiltsoft}

Hi @vinay singh ,

Unfortunately, the Table Transformer macro doesn't support "\n" as an empty line.

You can read more about different use cases with the Transformer macro here. If you need any further assistance, feel free to raise a support ticket, describe your use case and attach screenshots of your tables.