Solved

Export DSE to Excel

Forum|Forum|1 year ago
January 17, 2025
6 replies
0 views

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

Best answer by mikes0011

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

keshavd5650

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

gautams4173Author

So basically you are suggesting of doing this ?

a!queryColumn(
    field: "opsTicketId",
    alias: "Ops" & char(10) & "Portal" & char(10) & "Ticket" & char(10) &  "ID"
)

nilanshum856600

Char(10) is used for next line character and not for spaces. What [mention:d9e8692a66d942c1a28e256767471a14:e9ed411860ed4f2ba0265705b8793d05] 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"
)

mikes0011Answer

Brainy

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

gautams4173Author

Sure [mention:b45a4f6a20b14a008e4e0ec732a8bf98:e9ed411860ed4f2ba0265705b8793d05]

Sign up

Login with SSO

Login to the community

Login with SSO