Hi
I am using Export DSE to Excel smart service. Now in the configuration part, I am using the querySelection to select the columns to be written to the final excel document
Now this querySelection takes in queryColumn
Example :
a!queryColumn( field: "opsTicketId", alias: "Ops Portal Ticket ID" )
This alias is basically the header displayed on the excel sheet, but whilst using such aliases containing a ` ` space .. the smart service errors out and as a result I have to use underscore
Is there any way I could retain this space ? I do not want underscores on my header ... need it to be a proper header
Discussion posts and replies are publicly visible
Could you try using the character " " (ASCII code 8192) to insert spaces in the alias?
So basically you are suggesting of doing this ?
a!queryColumn( field: "opsTicketId", alias: "Ops" & char(10) & "Portal" & char(10) & "Ticket" & char(10) & "ID" )
Char(10) is used for next line character and not for spaces. What Keshav Dadhich is suggesting is to use the ASCII code 8192.
Try this code:
a!queryColumn( field: "opsTicketId", alias: "Ops" & char(8192) & "Portal" & char(8192) & "Ticket" & char(8192) & "ID" )
tried with char(8192) and was not working