Read a SQL field with the type binary

[FrankGrimm]

Hello together,

i have a connection to a SQL Server. Everything fine, but type of the field "GGUID" is binary.

The result of the dataload in Qlik is:

How can i convert the field GGUID during the load process data that i can use it?

Thanks to all!

Frank

[Angela_Zhou]

@FrankGrimm 

If you just want to load the binary(16) data type into Qlik in string format, with the same look as in your screenshot,  Why not modify your SQL statement to convert/cast binary to varchar like,

SQL SELECT
     CONVERT(VARCHAR(100), GGUID, 1) AS sGGID