Alteryx Verified Package Deal Rated A+

Random Sample % - Generates a random number or percentage of records passing through the data stream Formula - Create new data fields based on expression or by assigning a data relationship, or to update an existing field, can also reorder fields and change field types Text to Columns - Able to ...

boolean - ️️A single value of either TRUE or FALSE, can be used to categorize data that is dead or alive, numeric - determines the number or height of trees, is quantitative, it also includes seven different data types (both whole numbers and integers). string data type - a sequence of chara...

Which of the following are present in the configuration options for Alteryx Databases, Microsoft Excel workbooks, and CSVs? 1 - Delimiters 2 - First Row Contains Data 3 - Record Limit 4 - Output File Name - Record Limit and Output File Name How can data be added to a workflow with the Text Inp...

Which of the following statements are true? - The Output Data tool's configuration options change based on the output file type. To limit the number of input rows to 10 from a CSV file, where will you put the number 10 in the Configuration window? - Record Limit Data must be converted into info...

3 Ways to Add Tools to the Workflow - 1) Drag and drop from tool palette, 2) right click and insert from category menu, and 3) add from tool search Scalability - Accommodates multiple data sources at once in the same workflow; there is no row limit so can accommodate large data sets; those source...

Which of the following is not an available option for combining data in the Union tool? a. data type b. manual configuration c. column name d. column position - a. data type Which of the following file types support reading in multiple sheets? Select all that apply. a. .xls b. all listed opti...

True or false? A new macro will be searchable in Designer by default. · False · True - False Which of the following statements are true about spatial objects? The configuration of the Create Points tool allows data to be grouped. The Poly-Build tool cannot output more than two columns of data...

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 Dat...

Alteryx Server Service Layer > Database - Mongo DB which can be embedded or user-managed. This serves as a persistence layer for workflows, application files, job queue, results data, Gallery data, and scheduled jobs Gallery Administration > Subscriptions - Another name for a Studio. This a...

When a batch macro is NOT configured for grouping, its behavior will be similar to a traditional Join - False Why would you copy an input data tool to a new canvas when creating a Macro? - It's faster than creating a template input manually Ensures the macro process will map correctly to the in...

Input Data Tool - ️️Bring data into your workflow by selecting a file or connecting to a database (optionally, using a query). - Data lives OUTSIDE the workflow - Values update (are dynamic) - Must export workflow to share files - Data is configured based on the file type being imported -C...

What is the default field length for csv files and what should you do if one or more of your columns is going to be longer than that? - ️️254 characters, and manually change the length of the columns in order to avoid truncated values Find Replace Tool - ️️Search for data in one table (ak...

What happens in the Configuration Window of the Browse Tool if each value in the columns is unique? - "All values are unique" message displays What are the 3 ways to add the Browse tool to the workflow? - -Drag a Browse tool to the canvas, and connect it to an upstream tool. -Right-click on a ...