Data Manipulation

Which tool would you use to add a new calculated field that performs logic across multiple rows, such as calculating the difference between the current row and the previous row?

Which TWO settings in the Sort tool affect the order of the output records?

Which tool effectively removes all rows that contain a null value in a specific column?

When using the Join tool, what happens to records that do not have a match in the other input?

When using the Filter tool, what happens to records that meet the 'True' condition?

If you need to combine records from two different data streams stacked vertically, which tool should you use?

Which tool would you use to change the data type of multiple columns simultaneously?

Which tool is the most appropriate for removing whitespace from the beginning and end of a string?

Which tool is used to parse a single string field containing multiple delimited items into separate rows?

Which tool is best suited to convert a 'Long' dataset back into a 'Wide' format?

Which tool is best suited to convert data from a wide format (multiple columns) to a long format (fewer columns with header names in a single column)?

Which tool is best suited for assigning a category to records based on value ranges, such as labeling sales as 'High', 'Medium', or 'Low'?

Which tool should you use if you want to limit the number of records flowing through your workflow based on a specific position, such as the first 100 rows?

What is the primary function of the Union tool in Alteryx?

Which tool would you use to change the field names of several columns at once using a list from another file?

Which TWO tools can be used to split a single string column into multiple columns based on a delimiter?

Which tool configuration is required to append a constant value (such as a 'Report Date') to every row in a dataset?

You need to aggregate sales data to find the total sum per region. Which tool is most appropriate?

Which of the following is the most efficient method to remove duplicate rows from a dataset based on a specific unique key?

Which tool is used to create a new field that calculates the difference between two date fields in days?

Refer to the exhibit. You receive this error while using a Formula tool. What is the most likely cause?

Refer to the exhibit. The workflow runs without error, but the result column is entirely populated with 0s despite having 'Active' statuses in the input. What is the most likely reason?

Which THREE actions are commonly performed using the Data Cleansing tool?

What is the purpose of the 'Auto Field' tool?

Which tool provides the most efficient way to replace specific null values with a fixed 'Unknown' string in a categorical column?

When joining two datasets, which join type would you use to keep all records from the left input, even if there is no match in the right input?

You need to change the data type of a column from 'String' to 'Integer' because it contains numeric identifiers. What happens if the column contains non-numeric values like 'A101'?

What is the primary function of the 'Select' tool in an Alteryx workflow?

What is the result of using the Unique tool on a field with duplicate values?

Refer to the exhibit. You are using a Formula tool to calculate total revenue, but the workflow throws this error. What is the most likely cause?

Which tool configuration is the most efficient way to convert multiple column headers into a single 'Name' and 'Value' column format?

You have a dataset where dates are formatted as 'DD/MM/YYYY', but Alteryx requires 'YYYY-MM-DD'. Which tool should you use to convert this format most efficiently?

Which tool is the most efficient choice for transposing data from a wide format to a long format while preserving specific 'key' columns?

Which TWO of the following are true about the Summarize tool?

Which of these is the most effective way to handle a large dataset where you need to calculate the running total of a numeric field partitioned by region?

Which tool allows you to select, rename, and change the order of columns in your dataset?