Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

png image to SQL databse

benja123
6 - Meteoroid

how do I save a png image on a SQL databse ? and after that how do I load my png image into an other alteryx workflow ?

1 REPLY 1
BrianR
Alteryx Alumni (Retired)

Hi @benja123, you can use something like this - the family of Blob tools, located in the Developer tab. The attached workflow illustrates how to read in a given png image, convert it to a Base64 encoded field, then write to a SQL Table. In my test case, I wrote it to SQL Server. The 2nd container shows how to read in that blob, convert it back to an image, and then write it to a folder. Also in this test case, I used SQL Server, but assuming other databases should work similar.

 

BrianR_0-1598525939317.png

 

Brian

 

If this solves your issue, please consider marking this as Complete so others can find this as well.

Labels
Top Solution Authors