Alteryx Preparation Tools Questions and Answers (100% Pass)

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, and stops when condition criteria are met Random N% of Records Return an expected number of records resulting in a random sample of incoming data stream Master01 | September, 2024/2025 | Latest update 1 | P a g e | © copyright 2024/2025 | Grade A+ Sample Extracts a specified portion of records in the data stream Select Change metadata; rename or reorder columns, change data type, deselect unneeded columns, assign a description Sort Arranges records in alphanumeric order based on values in specific fields; can use Dictionary order for multiple languages Unique Classifies records as either unique or duplicate by grouping on one or more specified fields; uniques reported with unique anchor and duplicates with duplicate anchor Select Records Select specific records and or ranges of records including discontinuous ranges; useful for troubleshooting and sampling Data Cleansing Master01 | September, 2024/2025 | Latest update 1 | P a g e | © copyright 2024/2025 | Grade A+ 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 punctuation Multi-Row Formula Add new column or change row values based on expressions which are applied to multiple rows; can group based on fields; Row - 1 references row before current, Row + 1 references row after current; can specify other numbers of rows to apply; can only one field per tool instance Auto Field