Common Use Cases

Discussion List

• Changing Value in a Field Based on Condition

  Answered ✓ 12.2K views 7 comments 0 points Most recent by bwortham32 October 2016Alteryx One
• Changing Data Format

  Answered ✓ 4.1K views 6 comments 0 points Most recent by DataAnalyst October 2016Alteryx One
• Changing Data Format

  Answered ✓ 4.2K views 4 comments 0 points Most recent by DataAnalyst October 2016Alteryx One
• Look up date based on column value

  Answered ✓ 3.4K views 4 comments 1 point Most recent by dan_b September 2016Alteryx One
• Alteryx architecture/technology slide/document

  Answered ✓ 5.2K views 2 comments 1 point Most recent by MizunashiSinayu September 2016Alteryx One
• Data manipulation with rows & columns

  Answered ✓ 6.4K views 9 comments 0 points Most recent by pcatterson September 2016Alteryx One
• How to identify Columns which are not selected in "SELECT" Tool

  Answered ✓ 3.8K views 5 comments 0 points Most recent by ardsilva September 2016Alteryx One
• Adding Fields to my data

  Answered ✓ 8.8K views 2 comments 0 points Most recent by RodL August 2016Alteryx One
• Trim error

  Answered ✓ 3.8K views 2 comments 0 points Most recent by knozawa August 2016Alteryx One
• String character function for data quality testing

  Answered ✓ 3.3K views 3 comments 0 points Most recent by Wangwn August 2016Alteryx One
• Fuzzy Match matchscore

  Answered ✓ 4.5K views 3 comments 0 points Most recent by kennethli August 2016Alteryx One
• Adding a common international number to 700 mbl numbers

  Answered ✓ 2.6K views 2 comments 0 points Most recent by handerz August 2016Alteryx One
• Averaging Columns with the same Name

  Answered ✓ 2.5K views 1 comment 0 points Most recent by roadhouse August 2016Alteryx One
• Create one variables to retrieve values from existing variables under certain conditions

  Answered ✓ 5.4K views 3 comments 0 points Most recent by RodL August 2016Alteryx One
• Convert list of zip codes into ranges

  Answered ✓ 3.4K views 3 comments 0 points Most recent by PRossi August 2016Alteryx One
• Show values based on latest start Date

  Answered ✓ 2.5K views 1 comment 0 points Most recent by patrick_digan July 2016Alteryx One
• Select Columns based on Formula?

  Answered ✓ 9K views 5 comments 0 points Most recent by patrick_digan July 2016Alteryx One
• MULTI-ROW FORMULA PROBLEMS

  Answered ✓ 4.2K views 3 comments 0 points Most recent by MarqueeCrew July 2016Alteryx One
• Putting Values From Multiple Rows & Columns into One Single Column

  Answered ✓ 2.2K views 2 comments 0 points Most recent by brittany_harn July 2016Alteryx One
• Compare two log files

  Answered ✓ 5.6K views 4 comments 0 points Most recent by Wangwn July 2016Alteryx One
• More options for IF statements needed

  Answered ✓ 2.4K views 2 comments 0 points Most recent by ulrich_schumann July 2016Alteryx One
• Alteryx and Excel style countifs/sumifs with dates criteria

  Answered ✓ 9.9K views 5 comments 0 points Most recent by aleksi555 June 2016Alteryx One
• Something like Excel's "Solver" - to find adjustment coefficient for market share

  Answered ✓ 4K views 1 comment 0 points Most recent by JohnJPS June 2016Alteryx One
• Joining numbers with multiple criteria fields

  Answered ✓ 3.5K views 2 comments 0 points Most recent by Floris77 June 2016Alteryx One
• Syntax for empty

  Answered ✓ 18.2K views 6 comments 0 points Most recent by Aaron_dup_9 June 2016Alteryx One
• Remove building name from address before geocoding

  Answered ✓ 7.1K views 6 comments 0 points Most recent by pmckenn June 2016Alteryx One
• Batch Macro to do mapping

  Answered ✓ 4.3K views 4 comments 0 points Most recent by kennethli June 2016Alteryx One
• How to Value base on Maximum date for each year

  Answered ✓ 2.3K views 1 comment 0 points Most recent by jdunkerley79 June 2016Alteryx One