Export DSE to Excel

Question

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

Mike Schmitt · Accepted Answer

This seems like an error with the smart service node - can you submit a bug report ticket to Appian Support?

Keshav Dadhich · Answer

Could you try using the character " " (ASCII code 8192) to insert spaces in the alias?

Nilanshu · Answer

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"
)

Export DSE to Excel

Top Replies