Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Convert blob to Excel

Highlighted
7 - Meteor

Hi, I have a workflow which is extracting Excel documents from a Document Repository as blobs. Is there a way to convert these blobs to their original document type (.xlsx or xls) automatically?

 

Attached is the workflow producing the blob outputs.

 

Many thanks,

Sheila.

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi Sheila,

I can't access the URL from  my environment. Maybe you can post filestream blob (in a yxdb or text input), so I can see the results?

Thanks

Highlighted
7 - Meteor

Hi, I have attached some examples of the blobs - is that what you are looking for please?

 

I had to zip the files, as otherwise this forum did not accept the file format.

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi Sheila:

I got your files.

What I did was:

- Use a Blob Input Tool to get the original file:

 

1.PNG

 

-Add a Formula Tool (Just to create a "Dummy" field for the next tool:

 

2.PNG

 

-Use a Blob Output Tool to write the Excel to the disk:

 

3.PNG

 

- Finally, here is the Result:

 

4.PNG

 

Hope this helps.

Best,

_AG_

Highlighted
8 - Asteroid

How we handle clob value from a Database.

Highlighted
8 - Asteroid

Hi,

How can we read blob or varbinary data of a file from sql server.

Highlighted
8 - Asteroid

Hi ,

 

You can check a BLOB convert tool in Alteryx.

 

You can try and convert to HD5 of binary data.

Labels