c:\移行用\★デスクトップ\あるたよう\類似度\similaritymatch.yxmc
false
designerbasetools_venv
1
61026
741e7ff7-bafd-42d1-84d2-eb416f6f82cc
2021.1.4.26400
= validratio :\n"," lines.append([recid, src, recid_tgt, tgt, rslt.ratio()]) #append the data for output\n"," validrecordnum = +1 #add 1 if the valid record\n"," if validrecordnum == 0 :\n"," lines.append([recid, src, None, None, None]) #no valid records\n","\n","#make the Pandas frame for output\n","df = pd.DataFrame(lines,columns=['RecordID_S','Source','RecordID_T','Target','MatchRatio'])\n","\n","#output data to Designer\n","Alteryx.write(df,1)\n"]},{"cell_type":"code","execution_count":null,"metadata":{},"outputs":[],"source":[]}],"metadata":{"kernelspec":{"display_name":"designerbasetools_venv","language":"python","name":"designerbasetools_venv"},"language_info":{"codemirror_mode":{"name":"ipython","version":3},"file_extension":".py","mimetype":"text/x-python","name":"python","nbconvert_exporter":"python","pygments_lexer":"ipython3","version":"3.8.5"}},"nbformat":4,"nbformat_minor":2}]]>
0.1
Option
Option
Join Original Data and the result
Join Original Data and the result
___RecordID___
1
Int64
6
0
___RecordID___
1
Int64
6
0
Similarity Match Macro
Release notes
v1.0 2022/05/08 Initial Release Alteryx Designer 2021.1.4.26400
Allow
Source input
Input1
S
Windows 10
Windows 8.1
Mac OS
Ubuntsu
Cent OS 8.0-1905
Cent OS 8.5.2111
東京都港区
東京都 港区
iPhone
Source
Source
S Input
Target input
Input2
T
Windows 10
Windows 8.1
Mac OS
Ubuntsu
Cent OS 8.0-1905
Cent OS 8.5.2111
東京都港区
東京都 港区
iPhone 13
Target
Target
T Input
output
Output6
Output
output only the records with the highest similarity ratio
RecordID_S - Ascending
MatchRatio - Descending
First
1
First 1
Interface
数値増減 (12)
値を更新
チェックボックス (20)
値を更新
Horizontal
Question
数値増減 (12)
Question
チェックボックス (20)
SimilarityMatch
This macro is a similarity match using Python difflib's SequenceMatcher function. The difflib can calculate the similarity ratio by the Gestalt Pattern Matching algorithm. This macro outputs the S input data with the result of calculating the similarity ratio between the specified field of the S input and the specified field of the T input.
This macro has two options. One is that can output only the records with the highest similarity ratio. Another option is that output the records more than a threshold of similarity ratio that you set.
Join
match, fuzzy
Akimasa Kajitani
Akimasa Kajitani
NoCondition
(Always Run)
Dynamic
{{INPUT}}
4/Data/r[1]/c[1]
Update Cell
Expression
row 1
column 1
Dynamic
{{INPUT}}
18/DetourRight/@value
Update Detour Direction from Question
Expression
Tab
質問
タブ (11)
MacroInput
マクロ入力 (1)
MacroInput
マクロ入力 (2)
MacroOutput
マクロ出力 (6)
NumericUpDown
threshold of similarity ratio(0-1)
数値増減 (12)
BooleanGroup
output only the records with the highest similarity ratio
チェックボックス (20)
Macro
iVBORw0KGgoAAAANSUhEUgAAAKsAAACrCAYAAAAZ6GwZAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOwAAADsABataJCQAACgJJREFUeF7tnEGIXWcZhtOCdaXUlS4K6qpCBQXBhYiK0Dm3EcxCZlmDM+dOsKG4E3dDtdCZc6fUSgttEUJLoekqUBdCLXEhqRRKi1qwEiISCDTYTUtjo7W5/u+db0TGN/3mzv+f7/wneR94aEnynfOT++TMueece48IIYQQQgghhKiO+S33Tx795NrR2WfX7p59cX1l66sbk52vTyfb31xvZt+SN4d4vfG64/VHB+gBXaAPC2U4Vlc3bzvRPPS56crO19qmOzltul+m//5uOukuTpvZu20z+3A6mc3lzeHi9U6vO17/RQe7PZxEH+gEvVg6cWxubt6KnaeFHEuLe7qddJfZ4qWEiz7QSeqlvXv2efRjKfXL2ne3P7FxdPYN2/lVtjgpmYteUjfoBx1ZUv1w39HuM+093TTt+NL+hUi5hJfQEXqytMrSTrbuSOcgW+mQ/i+ycymXctHRoqetOyyxMqx/++efTjt4LJ04X9u/UykP76Knx9CXpZYHzi3SRn+mUGU/dtfaZvZg9jks3rWlE+J728nsA74jKfNFX+kc9vtZVwnWmu0708b0ZkpGeAm9WXrLsfGVJz+WNnBq3wal7NNT6M4SPDgnVh7+Uhp+f9/GpOzT99uj3ZctwYMyv2XadE+SjYX7k+NPzXd+fHp++omz8xeePbcQ/49fw++xGTlim9lTSz1LcPzYI7cPeQv1p/c9PX/pzKvzt996Z+6BP3PuxTcW8bJtyXGJ7tCfpeizPtk+yjbUtwjuL3+4aBkuD2YV7fhFf5aiTzuZbbON9OWPvveL+esvn7fk8sG2sE22L1m/6M9S9El/+DdsI32IH/kH+XG/LBcvXF5sm+1T1i36sxR90purC2wjpUVMV967anmVB9tWsCM09Wcp+qR3ZO/SjRS071D3wD50SjAyU3+Wok/fT/gjHvyYjgJvvNg6ZJ2iP0vRh22gpLgsFQ2uzbK1yDq1FH3YcClxIX8IdDowLi1FHzZcSlzAHwrc/WJrkvVpKfqw4RLiyDYkuETG1iXr01L0YcMlPPXwry2b4Xj8gTN0bbIuLUUfNlzCknepDgve3LG1ybq0FH3YcAkjrqt66DLWOLQUfdhwCWsA/2DY2mRdWoo+bDhX3LGqBbY+WZeWog8bzhWP7tUCW5+sS0vRhw3nqljlMlqKPmw416HuXDHY+mRdWoo+bLiENaAbA+PQUvRhwyWMfNLqeuBaL1ubrEtL0YcNl3CIp632o6evxqGl6MOGS1jDmyx9fHscWoo+bLiUfXze6qDo7tV4tBR92HAph3yYRR/THo+Wog8bLukQR1cdVcelpejDhksafe6K5wF0rjouLUUfNlxaPLUfBU492BpkvVqKPmy4DyM+4oJ9sH3LurUUfdhwX/YZrEIdr5aiDxvu0z5OCfSjf9xaij5suG/xvGuJ27F416+vDBq/lqIPG44SR8TDRIsZHU1vHC1FHzYcLY6OuI+PIyW7LovLUfg9nELoSHrjaSn6sGEpI7UUfdiwlJFaij5sWMpILUUfNixlpJaiDxuWMlJL0YcNSxmppejDhqWM1FL0YcO1iEf98IihPLxj+FJlS9GHDddi5KOFNyoIlv3d1qSl6MOGa1Gx5qNYg1Ss+SjWIBVrPoo1SMWaj2INUrHmo1iDVKz5KNYgFWs+ijVIxZqPYg1SseajWINUrPko1iAVaz6KNUjFmo9iDVKx5qNYg1Ss+SjWIBVrPoo1SMWaj2INUrHmo1iDVKz5KNYg8eVr+I4reXjH8N1glqIPG5YyUkvRhw1LGaml6MOGpYzUUvRhw1JGain6sGEpI7UUfdiwlJFaij5sWMpILUUfNixlpJaiDxuWMlJL0YcNSxmppejDhqWM1FL0YcNSRmop+rBhKSO1FH3YcC3qm6/z1TdfB6nnWfNBsOzvtiYtRR82XIuKNR/FGqRizUexBqlY81GsQSrWfBRrkIo1H8UapGLNR7EGqVjzUaxBKtZ8FGuQijUfxRqkYs1HsQapWPNRrEEq1nwUa5CKNR/FGqRizUexBqlY81GsQSrWfBRrkIo1H8UapGLNR7EGqW++zlfffC1lQS1FHzYsZaSWog8bljJSS9GHDUsZqaXow4aljNRS9GHDUkZqKfqwYTle8XVBuLZ6+omzi+vUe+LXar2MZSn6sGE5LvGdYC+deXV+8cJluxVwfa68d3X++svnF9ew2baG0FL0YcNyHCLScy++YRkuz9tvvVNFtJaiDxuW9VvyVjSOyEOeIliKPmxY1ivOSXEbtTQ4PRjqKGsp+rBhWacI9SDnpTkMEayl6MOGZX1GhLpHdLCWog8blvWZ80ZqWXBKEHkOayn6sGFZl7hGGg2O4mwtfWgp+rBhWZe4xDQEUacDlqIPG5b1iGCGAv9I2JpKayn6sGFZj1Fvqq7H4w+coesqqaXow4ZlHeIO1dDgjR1bW0ktRR82LOtwyFOAPXBlgK2tpJaiDxuWdYiHU2oAR3i2vlJaij5sWNZhH7dVD0PfH+e2FH3YsKzDWmLt+xKWpejDhmUd1hIrnvBi6yulpejDhmUd1hIrPnXA1ldKS9GHDcs61DnrPtiwrMPIh1c+ir4farEUfdiwrEP8+K0BtraSWoo+bFjWIY5oQ4MPF7K1ldRS9GHDsh6HeuJqj4gnryxFHzYs67HkBwOXBbda8QkFtq6SWoo+bFjWI2JBNEPQ9/XVPS1FHzYs63KIo2vUURVaij7TSXeNbUDWZfRzrRHPse7aXbMUfabN7J98I7Im8eRT1OlAxDOs/zX1Zyn6tJPuMt2IrE5cyuo72NBQk+jPUvSZNt1rbCOyTvsMNjrUhak/S9En/eFn6UZktSLY0uewfT+scl1Tf5aiT9t0J+lGZPXiKkHuURYPy/R97/+jRH+Wok/bbN2VBq6yDcn6xeUlRLvsnS78yO/7aSpPdIf+LEWfzc3NW9PgK/s3JMcnjpD4cY4QccT8X3GPH1EPHeg+X0F/luLBSOcNJ5L/JhuTsh/RW+rOEjw4x489cnvawJv/t0Ep+/NNdGcJLse02WnTOcQ/yEalLCo6a+/pppbe8qyubt6WDssv6Par7NfUV+rs/smjH7f0Dsdas31nqv6PfCdSlrD708bKzhcsuTzaZqdJGzzPdyRljt159GWplWFj0q22k+7PbTP7kO9UyoOLjtATurLEyrKx0k3SucXv9aZL5rjoJ3WEniytfrBz2OfSzv6mo6xcxkUvi26659CRJdUveNc2nWyvtZPZWdu5bs3K67roA52gl9RN9rv+w/DD7zz0qfWV2Q/SSfLzaTGvpf/+NS3s7+lf0JW0sA/YwuWNLV73xeufOkAP1sXz6AS9WDrDgXu5ePhg2szuTQt9MJ04P5MW/qvdf0ndb+XN4e7rjde9ewYd7PawddfS9/qFEEIIIYQYHUeO/Aev9eeteTrP4gAAAABJRU5ErkJggg==