Alteryx - General Questions And Answers Latest Updates

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 sources can exist in varying formats in one workflow 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 Safety - Designer offers a safe development environment for testing, exploring, and solving; by simply inputting data into the workflow, you are not overwriting the original file; you choose where and how to save the results 4 Components of Alteryx Designer - 1) Tool Palette, 2) Configuration Window, 3) Canvas, 4) Results Window What do red exclamation marks on a workflow mean? - A tool is not configured properly or an expression parse error . 4 Benefits of Alteryx - 1) Transparency, 2) Repeatability, 3) Safety, 4) Scalability .XLSX (Excel) workbook configuration - Data stored in tabular format; can specify record limit (extra files created if limit exceeded); can search subdirectories; can start import on a specific line; can output file name as a field; can specify 1st row as headers or data .YXMD (Alteryx Database) configuration - Most efficient file type to import data; can specify record limits; can search subdirectories to import files of a similar type or structure; can output file name as field Tool Palette - Contains the tools used for data manipulation; separated into categories based on the function they perform; each have a color and shape combo that is uniqueCanvas - Area where tools are connected to form a workflow; can right click on canvas to search tool menus Configuration Window - Allows user to customize configuration options; changes based on tools selected; if config is incorrect, a red exclamation mark will appear below the tool Results Window - Populates on workflow completion information on how the process was run and links to imported and exported files; error messages show up in red 5 Data Types - String, Numeric, Boolean, Spatial, and Date/Time Number (Numeric) - Data that is quantitative in nature which can be used in calculations; 7 types: 1) Byte, 2) Int 16, 3) Int 32, 4) Int 64, 5) Fixed Decimal (typically used for currency), 6) Float, 7) Double; Double is the most precise, and byte is the smallest Date/Time - Date in YYYY-MM-DD format (10 characters) and time in HH:MM:SS (6 characters) Boolean - Smallest data type supporting two values: 0 for False or 1 for True Spatial Objects - Spatial objects like centroids, polygons, lines, or a point on a graph with X & Y coordinates What is the file extension for an Alteryx workflow? - .yxmd What is the file extension for an Alteryx database? - .yxdb What is the file extension for an Alteryx macro? - .yxmc What is the file extension for an Alteryx analytic application? - .yxwz What is the file extension for an Alteryx workflow group? - .yxwg What is the file extension for an Alteryx packaged workflow? - .yxzp What is the extension for an Alteryx Field Type file? - .yxft - describes the file configuration of field names and field types; can then be added to a workflow with Select tool or any tool with embedded Select What is the file extension for an Alteryx backup file? - .bakHow many string data types are available in Alteryx? - String, WString, V_String, V_String: Forced, V_WString For fixed length string fields (String, WString), what is the character limit? - 8,192 T/F The WString can accept any character, not just Latin-1 characters. - True