Alteryx Questions and Answers (100% Pass)

Text Input Manually add data which will be stored in the workflow Input Data Bring data into you workflow by selecting a file or connecting to a database (optionally, using a query) Output Data Output the contents of a data stream to a file or database Browse View data from a connected ...

All tools in Designer are Macros (T/F) False What file type are Macros saved as? .yxmc Select all that are TRUE 1. Macros use Interface Tools to Generate their configuration windows 2. All Analytical Apps contain at least one macro 3. To open a Macro, a user must have Designer installed on ...

All tools in Designer are Macros False What file type are Macros saved as? .YXMC T/F: Only standard macros can include custom help documentation False Dragging a Macro Input Tool onto a canvas will automatically change the workflow configuration to which type? Standard Macro Macro asso...

Any value entered into the Text Input tool is characterized as a string data type T/F False Cells that are left blank in the Text Input tool are assigned what value? A - Empty B - Null C - Zero (0) Null How can data be added to a workflow with the Text Input tool? Choose all that apply...

What are the two sections of the Input Data Configuration window? Connect a File or Database AND Options What does entering "*" do with an input file? It brings in anything that starts with the characters before the "*" and anything after it What does entering "?" do with a...

Record ID Assigns a unique numeric value to each row of data 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 Multi-Field Formula Applies the same expression to all selec...

Safety Designer offers a safe development environment for testing, exploring and solving. By simply inputting data into the workflow, you are not overwriting the existing file. You choose where and how to save results Output Data Tool -Output the contents of a workflow to a file or database...

Navigating to the Alteryx Gallery (and changing base adress) Users can navigate to the Alteryx Gallery using a browser. The address is typically named: http://(ServerMachineName)/gallery, but this can be changed in the Alteryx System Settings under Gallery > General Districts Alteryx wor...

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

4 Benefits of Alteryx 1) Transparency, 2) Repeatability, 3) Safety, 4) Scalability Transparency You have visibility of all the actions performed on the data set; the workflow shows what steps were taken and the order in which they were performed Repeatability Use a workflow to perform ma...