Designer | Data Encryption

[shamv]

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

[geraldo]

@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

[shamv]

Hi @geraldo ,

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

Many thanks,

Shamv

[jdminton]

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.