Alteryx preparation tools - Study guides, Class notes & Summaries

Random N% of Records - Return an expected number of records resulting in a random sample of incoming data stream Generate Rows - Create new rows of data at the record level; create rows incrementally based on the initial expression, loop expression, and stops when condition criteria are met Data Cleansing - Perform basic data cleansing operations such as replacing null values, eliminating null rows or colums, removing whitespace (leading and trailing), and modifying case or removing punct...

Filter Allows user to restrict data based on certain criteria; queries records in file to meet specified criteria; two output anchors - T for records that match criteria and F for records that do not match criteria Formula Derive new column or modify existing column by using expressions to perform a broad variety of calculations and/or operations Generate Rows Create new rows of data at the record level; create rows incrementally based on the initial expression, loop expression, ...

Alteryx Preparation Tools Exam Study Guide with Complete Solutions Filter - Answer-Allows user to restrict data based on certain criteria; queries records in file to meet specified criteria; two output anchors - T for records that match criteria and F for records that do not match criteria Formula - Answer-Derive new column or modify existing column by using expressions to perform a broad variety of calculations and/or operations Generate Rows - Answer-Create new rows of data at the recor...