Designer Core: Data Manipulation

Question 1

There are 6 tools on this exam. What are they?

Answer 1

Append Fields, Union, Join, Find/Replace, Date Time, Text to Columns

Question 2

What does Append Fields do?

Answer 2

Adds the columns from a source input to every row in a target input. Each row of the target input will be duplicated for every row in the source input

Question 3

What does the Union tool do?

Answer 3

Combines multiple data streams based on common column names or positions. In the output, each column will contain data from each input and rows will be stacked vertically

Question 4

In the Union tool, what does Output Common Subset of Fields mean?

Answer 4

This removes the extra column not found in the other input

Question 5

How do the Join and Union tools merge data sets differently?

Answer 5

A union tool puts rows from 2+ streams on top of each other (vertically)
A Join tool puts rows from 2 streams next to each other in the same row (horizontally)

Question 6

What does the Join tool do?

Answer 6

Combines 2 data streams based on common fields or record position. In the joined output, each row will contain the data from both inputs

Question 7

What does the Find Replace tool do?

Answer 7

Finds instances where a string contains a lookup list value, and either replaces it or appends additional columns to the table when a match is found

Question 8

In the Find Replace tool, what does checking the “Match Whole Word Only” option do?

Answer 8

This ensures that only substrings surrounded by spaces and or at the start or end of the string will be replaced

Question 9

What does the DateTime tool do?

Answer 9

Transforms datetime data to and from a variety of formats

Question 10

What is the standard datetime format in Alteryx?

Answer 10

yyyy-MM-dd hh:mm:ss

Question 11

What does the Text to Columns tool do?

Answer 11

Splits the text from 1 column into separate rows or columns