cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Knowledge Base

Definitive answers from Designer experts.
 You are using an unsupported browser for translation. Please switch to another browser.

Every so often we get questions about a .tde (Tableau Data Extract) file that is being output from Alteryx that has a file size of 30k when the original data is much larger. When the file is opened in Tableau this error sometimes comes up: An error occurred while communicating with data Source ‘yourfilename.tde’
View full article
As long as you know where to look, data has all the answers. Sometimes, though, those answers aren’t clear as day. More often than not, they need to be communicated in an effective format - a format that can let the data talk and highlight the important motifs for you. Another favorite of the Reporting Tool Category , the Charting Tool can do just that by adding expressive visuals to any report or presentation. Offering an exhaustive list of charts to choose from (area, stacked area, column, stacked column, bar, stacked bar, line, tornado, pareto , box and whisker, scatter, bubble, polar, radar, pie), the Charting Tool will give you the ability to add descriptive visuals, with legends and even watermarks, to your reporting workflows that will help you find the answers in your data.
View full article
The partnership between Alteryx and Tableau is becoming stronger and stronger, and the seamless effortless integration has been made easier through the Publish to Tableau Server Tool. This article demonstrates the use of the Publish to Tableau Server tool, available on the Alteryx Analytics Gallery.
View full article
  ISSUE:   Error “ Error: Publish to Tableau Server (1): Tool #252: Tool #4: Tableau Server API Request (Publish file) Error Code 400011: Bad Request -- There was a problem publishing the file ‘ ’ “ when publish .hyper file of Excel with data source metainfo (.tds) file.   Repro Step:   Connect to an Excel file on Tableau Desktop Create an Extract with .hyper extension Then right click on the data source > add to Saved Data source, to create the metadata file (.tds) file Open Alteryx Designer, connect to the same Excel file using input tool Drag a publish to Tableau Server tool, type in all the relevant information, for Data source metainfo (optional), select the .tds file created in step 3 When run the workflow, this error would occur   Resolution:   Option 1 Do not create extract of the file, for text based file, do no need to create a local copy After created the .tds file (add to Saved Data source) , open the .tds file in a text editor like notepad ++ Modify on line 8, where filename = ‘ ’, change the path to UNC path + The original one looks something like: filename='H:/output.xlsx' + Change it to something similar to the following: filename='\\extendthereach.com\alteryx\CustomerSupport\output.xlsx'   Note: As a best practice, have the original Excel file in a share drive if it need to be used for other users in the organization or it will need to refresh on Tableau Server in the future. And make sure Tableau Server Run As User account has the sufficient permissions to access the share drive.   Option 2 -   If the Excel file has to be located on the end user’s machine, change the path in TDS file (line 8) to something like the following when the file in on local machine:    filename='\\?\C:\Users\kchen\Documents\Example named ranges.xlsx'   Note: If the Tableau Server Run As account does not have sufficient permission to access the share drive where the file is located, the following error would occur when connected to the Data source on Tableau Server:     “Unable to connect to the file "C:/Users/<Username>/Document/filename.xlsx". Check that the file exists and that you have sufficient access privileges for it. DataServiceFailure Unable to connect to the server "localhost". Check that the server is running and that you have access privileges to the requested database.”     See following Tableau KB for more information: https://kb.tableau.com/articles/issue/error-unable-to-connect-to-the-file-file-path-Check-that-the-file-exists-and-that-you-have-sufficient-access-privileges-for-it-refreshing-extract  
View full article
 When attempting to publish a workflow to your private Gallery which contains the Publish to Tableau Server macro, you may encounter an error similar to this:   “ Cannot find macro "PublishToTableauServer_v1.08.1\Publish to Tableau Server.yxmc"   This is typically due to one of two reasons:   The Publish to Tableau Server macro has not been installed on the Alteryx Server where the Gallery is located. The macro has been installed but has not been installed in the correct location, or the Gallery cannot access the macro for other reasons. Please see this link for instructions on correctly installing the Publish to Tableau Server macro on an Alteryx Server.   Even when the macro has been installed properly on the server, this issue can still occur, and if it does, here is a simple workaround to get your workflow published:   Save the workflow to the Gallery: From Designer, click on File > Save As and choose your Gallery. Add the Tableau macro components as assets of your workflow: Click on Workflow Options > Manage workflow assets. Select all of Publish to Tableau Server related assets (currently there are four). Including these assets when publishing should allow the workflow to publish and run successfully in the Gallery.   Thank you!
View full article
Users often ask, "How do I do (x) function in Alteryx?" - here's a handy guide for translating Tableau functions for use in Alteryx!   *Please note: This is not a comprehensive list of all functions available in Alteryx and Tableau - only functions that are written differently, but perform similar tasks, are included here. For a list of all the functions available in Alteryx, please refer to our Help Documentation.   Number Functions  Alteryx  Tableau CEIL(x) CEILING(x) Return smallest integer greater than or equal to [x]. Works like the 'RoundUp' function in Excel. MOD(n, d) x % y Modulo of n divided by d - The Modulo operation finds the remainder of division of one number by another number. POW(x, e) POWER(number, power) Return [x] raised to the [e] power. Round(x, mult) ROUND(number, [decimals]) Return [x] rounded to nearest multiple of [mult]. IF isnull([field]) THEN 0 else [field] ENDIF or Contains([field], "string") ZN(expression) Returns the expression if it is not null, otherwise returns zero. Use this function to use zero values instead of null values.   String Functions IF Contains([field], "string") then 1 ELSE 0 ENDIF Contains(string, substring) Returns true if the given string contains the specified substring. FindString(string, Target) FIND(string, substring, [start]) Searches for the occurrence of a particular string within a data field and returns the numeric position of its occurrence in the string. In Tableau, returns the index position of substring in string or 0 if the substring isn't found. If the optional argument start is added, the function ignores any instances of substring that appear before the index position [start].* Length(x) LEN(string) Return the length of the string [x]. LowerCase(x) LOWER(string) Converts a string to lower case. REGEX_Match(string, pattern, icase) REGEXP_MATCH(string, pattern) Searches a string for an occurrence of a regular expression. REGEX_Replace(string, pattern, replace, icase) REGEXP_REPLACE(string, pattern, replacement) Allows replacement of text using regular expressions and returns the string resulting from the RegEx find pattern and replace string. Substring(x, start, length) MID(string, start, [length]) Return the substring of [x] starting at [start] and stopping after [length], if provided.* TRIMLEFT(x, y) LTRIM(string) Remove character in the string y from the end of the string x; y is optional and defaults to trimming white space. In Tableau, this function trims extra whitespace. TRIMRIGHT(x, y) RTRIM(string) Remove character in the string y from the end of the string x; y is optional and defaults to trimming white space. In Tableau, this function trims extra whitespace. Uppercase(x) UPPER(string) Converts a string to upper case.   Date Time Functions DateTimeAdd(datetime, interval, units) DATEADD(date_part, interval, date) Return the given date/time modified by the given duration. The <interval> specifies a positive or negative integer of time to add or subtract and <units> is one of a date/time unit - "years", "months", "days", "hours", "minutes", or "seconds". For Tableau, additional date_part units are allowed. DateTimeDiff(datetime1, datetime2, units) DATEDIFF(date_part, date1, date2, [start_of_week]) Subtract the second argument from the first and return it as an integer difference. The duration is returned as a number, not a string, in the specified units - "years", "months", "days", "hours", "minutes", or "seconds". For Tableau, additional date_part units are allowed. DateTimeTrim(datetime, trim type) DATETRUNC(date_part, date, [start_of_week]) Remove unwanted portions of a date/time and return the modified date/time. Options include: firstofmonth, lastofmonth, year, month, day, hour, minute. In Tableau, truncates the specified date to the accuracy specified by the date_part. This function returns a new date. For example, when you truncate a date that is in the middle of the month at the month level, this function returns the first day of the month. The start_of_week parameter is optional. DateTimeNow() NOW( ) Returns the current system date and time. DateTimeParse(datetime, format of incoming string) MAKEDATE(year, month, day) Converts a date string with a specific format to the standard ISO format yyyy-mm-dd HH:MM: SS. In Tableau, returns a date value constructed from the specified year, month, and date. DateTimeToday() TODAY( ) Returns today’s date. The time is set to midnight of the beginning of the day. Returns the current date.   Conversion Functions ToNumber(x, bIgnoreErrors, keepNulls) INT(expression) or FLOAT(expression) Converts a string parameter to a number. The second parameter is optional and allows for ignoring conversion error messages. This parameter is a boolean flag and will accept a value of 1, 0, true or false. There is an optional 3rd parameter to handle Nulls. In Tableau, INT casts its argument as an integer. For expressions, this function truncates results to the closest integer toward zero. FLOAT casts its argument as a number with decimal/float precision. ToString(x) STR(expression) Casts its argument as a string.   *In Alteryx, string positions start at 0. In Tableau, string positions start at 1.
View full article
Craig Bloodworth from The Information Lab posted the below in the Community Forum discussing a macro he has built to make pulling information from MongoDB easier!    Building on this KB article I've created a macro which will do all the work for you and allow you to send the data into your favourite data storage device.   You can download just the macro from the gallery.   If you use Tableau and want to take advantage of a pre-built workbook take a look at this workflow.   There's also a blog post on The Information Lab website.   Here's some screenshots of what you can extract:      
View full article
Question Is it possible to change a Qlikview Dashboard to Tableau using Alteryx? Answer Alteryx is able to read Qlikview data files (*.qvx) via the Input Data Tool. You can then use the Output Data Tool to create tableau data files (*.tde).  While it is possible to move the data visualizations, it cannot be converted. Try simply reading in the Qlikview file and outputting to a Tableau file; you will need Tableau desktop to build the new Tableau dashboard.    Input data - browse to .qvx file:     Output data - browse to new .tde file:     Sample .tde extract:  
View full article
I recently set up an app that got me One Step Closer to Alteryx Nirvana. Check it out!
View full article