notes on helpful alteryx tricks
How the detour tool works: https://community.alteryx.com/t5/Engine-Works-Blog/Detours-Empty-Fields-and-Rankings/ba-p/27195
Example of Detour functioning: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Change-Detour-from-left-to-right/m-p/111919#M34457
Lua script is for configuring ODBC Driver that is not native to Alteryx.....do we need to make this for Informix to work properly in database? --was made for partners to develop, not for normal users file:///E:/ProgramFiles/Alteryx/bin/RuntimeData/ODBC/Customizable%20ODBC%20Driver%20Connections.pdf
User Configuration setting file: --not sure if modifying this truly works https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Unable-to-Find-Oracle-Client/ta-p/177241
Where Alteryx resides on computer -helpfull for debugging python tool installations https://community.alteryx.com/t5/Dev-Space/How-to-Install-Custom-Tools-to-Alteryx-installed-in-Roaming/td-p/167810
Workflow organization: https://community.alteryx.com/t5/Community-Lounge/Do-you-have-an-organizational-or-personal-way-of-documenting/td-p/44768/page/2
Python depedency install issues: https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Including-Wheel-Files-With-Python-Tools/ta-p/188093
Using parameter from part of workflow to drive other part, like primary key in table https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Controlling-the-order-of-events/ta-p/5051
Simple example of Batch macro https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Dynamic-Filter/ta-p/9922
Great example of how a batch macro should work with a control parameter https://community.alteryx.com/t5/Live-Training/Live-Training-Build-Your-First-Batch-Macro/td-p/52900
Driver Downloads https://pages.alteryx.com/Alteryx-Driver-Downloads-LP.html
Updating corrupt xml Excel Data: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Output-to-Excel-error/td-p/49262/page/2 https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Using-Render-and-output-file-tool-to-same-excel-workbook/td-p/330908 Fuzzy Matching: https://www.youtube.com/watch?time_continue=1247&v=DmfWsEjKRTU