CReW SHA256 Encryption

[#1]

I was looking for a SHA256 encryption tool and couldn't find one (2022-08-02), so with the help of @grossal we used python (sparingly) and created this macro.  While useful for encryption of email addresses, it can be used on any string data.  The macro will give you CONVERSION warnings if you have EMPTY data and will enforce lowercase on you.  If you don't like these features, you can turn them off.

Incoming data is routed (top) to a JOIN tool and the SHA256_INPUT & RecordID are SELECTED to process through the macro.  Warnings and lowercase conversion of data are optionally processed on just the minimum data columns for efficiency.  A filter tool prevents empty data from being encrypted (Python will fail on empty data).  The data is brought back together and appended (as the last field) to the original data.  CReW tests (Expect 0) are performed to FAIL if any un-Joined data exists (I think that is impossible, but good practice here) an ERROR will occur.  The output then is returned to you.

Cheers,

Mark

When you need to use Python, use it.  This macro uses python to achieve the goal of SHA256 encryption of a single text field.  For those who know me, please don't think that anyplace has frozen over or that the end of the world is near just because I wrote a macro using python.

[NeilR]

[MarqueeCrew]

@NeilR ,

Do you need my t-shirt size or address?  Just wondering ...

thanks for the like

Cheers,

Mark

[e918141]

May I know whats the yellow tool on the output data?
It's missing when I opened it on 2021 alteryx

[MarqueeCrew]

It's a CReW expect records test tool to make sure data is coming out. 

https://community.alteryx.com/t5/Public-Community-Gallery/CReW-Expect-Records/ta-p/984111

cheers,

 mark