Designer | Data Encryption

Question

Hi All,

I need to create a flow that encrypts an input csv/xlsx file; having previously searched this topic I came across an article where someone had achieved this Alteryx: Encrypting Data | Inspiring Ingenuity.

However the linked method requires Alteryx for encryption and decryption. I need to encrypt the data, which will eventually be sent to SFTP for a customer to pick up. They do not have Alteryx and wont be able to decrypt the data.

I need a flow that uses P2P encryption for the input file that can be decrypted with an SSH key or other method by the customer.

Any help greatly appreciated

Thanks,

Shamv

jdminton · Answer

The SFTP should have its own encryption. If you're not trying to mask from others on the SFTP authorized to access the workflow, you may be doing too much.

shamv · Answer

Hi @geraldo ,

Can I confirm how the customer may be able to decrypt this file, the encryption does seem to work

Many thanks,

Shamv

geraldo · Answer

@shamv

Have you tried if the MD5 alteryx function can help with your need?
MD5_ASCII([_CurrentField_])
in this example it is column by column and all have to be without characters

MD5 is standard for conversion