Free Trial

Community Gallery

Create, download, and share user-built tools and workflows.
Looking for Alteryx built Add-Ons?

Easily shop verified, supported, and secure Partner and Alteryx built Add-Ons on Marketplace.

LEARN MORE
Comments
NeilR
Alteryx Alumni (Retired)

NeilR_0-1659551830577.png

 

MarqueeCrew
20 - Arcturus
20 - Arcturus

@NeilR ,

 

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

 

thanks for the like

 

Cheers,

 

Mark

e918141
5 - Atom

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

MarqueeCrew
20 - Arcturus
20 - Arcturus

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
5 - Atom

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)