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

[WarrenListdata]

Hi

I have been playing with this SHA256 macro - it works on small files, but when I go over 100k it crashes. this is the error?

Error: CReW SHA256 (2): Tool #1: Traceback (most recent call last):
File "E:\Temp\Engine_26628_46480c1d4f304e6fae5266143accd3c9_\c3c1b7006d9e485191c6cb3f1a6261bf\workbook.py", line 14, in <module>
df['SHA256_Output'] = df.apply(lambda row: text_to_sha256(row['__SHA256Input__']),axis=1)
File "C:\Users\warre\AppData\Local\Alteryx\bin\Miniconda3\envs\DesignerBaseTools_venv\lib\site-packages\pandas\core\frame.py", line 7541, in apply
return op.get_result()
File "C:\Users\warre\AppData\Local\Alteryx\bin\Miniconda3\envs\DesignerBaseTools_venv\lib\site-packages\pandas\core\apply.py", line 180, in get_result
return self.apply_standard()
File "C:\Users\warre\AppData\Local\Alteryx\bin\Miniconda3\envs\DesignerBaseTools_venv\lib\site-packages\pandas\core\apply.py", line 255, in apply_standard
results, res_index = self.apply_series_generator()
File "C:\Users\warre\AppData\Local\Alteryx\bin\Miniconda3\envs\DesignerBaseTools_venv\lib\site-packages\pandas\core\apply.py", line 284, in apply_series_generator
results[i] = self.f(v)
File "E:\Temp\Engine_26628_46480c1d4f304e6fae5266143accd3c9_\c3c1b7006d9e485191c6cb3f1a6261bf\workbook.py", line 14, in <lambda>
df['SHA256_Output'] = df.apply(lambda row: text_to_sha256(row['__SHA256Input__']),axis=1)
File "E:\Temp\Engine_26628_46480c1d4f304e6fae5266143accd3c9_\c3c1b7006d9e485191c6cb3f1a6261bf\workbook.py", line 11, in text_to_sha256
h.update(text.encode('ascii'))
UnicodeEncodeError: 'ascii' codec can't encode characters in position 21-23: ordinal not in range(128)