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

[vinay singh]

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_ · Accepted solution]

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.

[Katie A]

@vinay singh  Probably too late for you, but maybe not for other searchers...

If your original selection was actually this:

SELECT 'str1' + "\n\n" +'str2' FROM T1

Try this:

SELECT FORMATWIKI('str1' + "\n" + 'str2') FROM T1

(the header will show as that formula if you don't put "AS 'name' before FROM)

SELECT FORMATWIKI('str1' + "\n" + 'str2') AS 'name' FROM T1

I know it looks like one new line but in my confluence it shows up as 2 (and I have the opposite issue...I just want ONE lol)