blob conversion error

[avuong6]

hi – I have the following workflow that runs a sql query and outputs to excel:

One of the columns results is in blob data type by default:

I added a blob converter so that I could display the results in an excel sheet, but it didn’t work.

This is the result:

This is the correct code:

ACSEQ_GUID - 0A3C4B6B0D1D1EEB87A435154263D753

What to do to correct?

[gawa]

hi @avuong6 

You are checking "MD5 hash" option in blob converter tool, which returns a hash value.  Hash value is used for security purpose like message digest, and doesn't show data itself.

If you want to see a hexdecimal format blob data, then check "Convert to Hex Encoded Binary data".

[avuong6 · Accepted solution]

to resolve this, i converted the column data type in the sql. the column then came over to alteryx as text which solved the issue.