cancel
Showing results for 
Search instead for 
Did you mean: 
 You are using unsupported browser for translation.Please, switch to other browser.

Alteryx Knowledge Base

Lookup the term "date" in community and you'll get 2,000 results.  Hidden in this article are Easter eggs for the finding.  Besides learning about dates, see if you can uncover the clues that I've cloaked.
View full article
PRODUCT: Alteryx Designer and Alteryx Server   VERSION: 11.0   LAST UPDATE: 02/15/2017   ATTACHMENT: None  Connecting to Oracle in Alteryx 11.0 The Oracle connection has been redesigned for Alteryx 11.0 and it is now much easier to connect!  Existing Oracle connections and Aliases will function the same in Alteryx 11.0 as they did in previous versions but there are some differences in how new connections are established.    If you have NEVER connected to Oracle before.... (Note: an Internet connection is required for this option)    1. Add an Input tool to the canvas and select Oracle Click the drop down arrow to bring up the connection options.     2. Select a directory to install the client A window will appear prompting you to select a directory to install the client. Best practice is a to use a new empty folder you created for Alteryx to install the driver to. Alteryx will then download the appropriate client and install it for you. This should take a few minutes.     3. Create a Saved Oracle Database Connection Enter information in the database connection window to create a new Oracle Saved Database Connection.   Simply start typing in the Connection Name box to create a new Connection Name you will later use to identify the connection.  Your Oracle DB Admin will have to provide the Host, Service Name and Credentials.     4. Test the connection then click OK to connect Errors that start with ORA- and a number, such as the one below, are thrown by the database. Verify that your connection information (host, service name, port, username, password) are correct and that you have access to the Oracle database.     5. Create your query If your connection test was sucsuccessfullick OK to connect to the database and create your query using the Visual Query Builder, Tables Tab or SQL Editor. Note: Stored Procedures are currently not supported for Oracle.    6. Use the Saved Database Connection Going forward, Alteryx will not ask to install the driver again. It will recognize the driver previously installed.  If you need to connect to the same database in another input tool, you can find the connection in the drop down option.  If you need to connect to a different database, you can repeat steps 3 - 5 for the new database.     If you have connected to Oracle before.... ....or if you want to use an existing Oracle client on your machine.     1. Add an Input tool to the canvas and select Oracle Click the drop down arrow to bring up the connection options.  Alteryx will search your machine for an existing Oracle client.     2a. If Alteryx can find an existing client:  The Oracle Database Connection window will appear.  The drop down will reveal Aliases (now called Saved Data Connections) created in previous versions of Alteryx. You can also start typing in the Connection Name window to create a new Saved Data Connection for Oracle.     2b. If Alteryx cannot find an existing client... ... and you have the appropriate permissions on your machine, internet access, don't care if you use an existing driver, and your Oracle DBA did not tell you that you must use a specific client: Follow the instructions for users who have never connected before to install the Oracle Instant Client through Alteryx and use it to connect.  Note: This will ignore any clients previously installed on the computer and it should not interfere with them.  This is a good option to use if you are currently using a 32 bit client and want to use the 64 bit client for Alteryx.     2c. If Alteryx cannot find an existing client... ...but you have a client you want/must use to connect:   Most likely Alteryx can't find the existing client because it couldn't find Oracle Home in the Windows Environmental Variables and/or there was no tnsnames.ora file in the Oracle Home Directory. You can force Alteryx to use the existing client by setting the Environmental Variable and creating a tnsnames.ora file.    To do so:  - Close all instances of Alteryx - Navigate to the folder containing the Oracle client files - Create a blank text file called tnsnames.ora. Be careful not to save with an extension such as .txt or .csv and save to the folder - Copy the path of the folder - Open up Windows Environmental variables and create a new one called TNS_ADMIN with the path for the Oracle client file folder as the value --> If you already have a tnsnames.ora file, or a TNS_ADMIN variable, do not overwrite any of these - Open Alteryx and try connecting again   If you want to connect the "Old" way.... ... or if you want to use a tnsnames.ora file.   The new Oracle connection uses the Oracle instant client but it doesn't use any tnsnames.ora files you might have on your computer. If you have multiple entries in the tnsnames.ora file, you would have to create a new Saved Data Connection for each of those entries or you have the option to use the tnsnames.ora file.   In the Input tool, navigate to Other Databases and select Oracle OCI (Oracle Call Interface):  This will display the screen familiar from previous versions of Alteryx allowing you to enter the TNS Service Name from your tnsnames.ora file.    Note: if you set up Aliases in previous versions using the Oracle OCI connection, they will continue to function in Alteryx 11.0 as they did in Alteryx 10.6 unless you edit the connection.        If you must use a 32 bit driver.... ... as required by your IT You will have to navigate to Other Databases > 32 bit Database Connections and then select ODBC or OCI as appropriate.    In order to use these connections, you will need to have the driver already installed and a tnsnames.ora file created in the Oracle Home directory.  If you are using ODBC you have to set up a connection through the Windows ODBC Data Sources Administrator before attempting to connect through Alteryx.  To connect using the Oracle Call Interface (OCI), enter the TNS Service Name as it appears in your tnsnames.ora file and the username and password:    If Alteryx cannot locate the driver, see step 2c (Alteryx cannot find an existing client but you have a client you want/must use to connect) above. 
View full article
Alteryx Server provides a fully scalable architecture that allows an organization to scale Alteryx to automate data analytics, tackle bigger projects, process larger datasets and put self-service data analytics into the hands of more decision makers. From scaling Worker nodes to Gallery nodes to the MongoDB persistence layer, Alteryx Server allows organizations to efficiently manage their automated and self-service data analytics needs.
View full article
In a workflow, not too far, far away...       Structured data has vanished. In its absence, the sinister Dirty Data Order has risen from the ashes of the Server and will not rest until Data Analytics have been destroyed. With the support of the Alteryx Engineers, Solutions Engineer Tony Moses leads a brave RESISTANCE. He is desperate to find structured data and gain its help in restoring blending, joining and analytics to the galaxy.   Tony has sent his most daring Community Leader, Matt DeSimone, on a secret mission to Jakku, where an old ally has discovered a clue to the structured data whereabouts....   Welcome to the Star Wars universe!   Ever wanted to know the most important details of your favorite characters from Star Wars? Me too!    Our generous friends, Paul Hallett and team, have given us the Star Wars API - the world's first quantified and programmatically-accessible store of Star Wars data.   After hours of watching films and trawling through content online, Paul presents us all the People, Films, Species, Starships, Vehicles and Planets from Star Wars.   The data is formatted in JSON and has exposed it to us in a REST implementation that allows us to programmatically collect and measure the data.   Now, how was I able to retrieve this treasure of information via Alteryx? Easy! I've built a REST API connection using the Download Tool to pull information based on a user inputted query in an Alteryx Application (attached as v10.6 Star Wars.yxwz).   Normally, once having retrieved JSON formatted data, structuring and parsing the data would be a nightmare! With Alteryx, this is just one tool away. The JSON Parse Tool allows you to identify the JSON field, in this case our download data field, and easily extract Name and Value columns. From there it's some simple formatting and using the reporting tools to present us a nice clean composers file (pcxml).   Man, if only the Rebels could process information as fast as Alteryx then they wouldn't have had to send poor R2 to find Obi Wan.    I'll be bringing you, the Alteryx Community, updates of the app with each new movie release!   I hope you enjoy the API and may the Force be with you!
View full article
Quick navigation for the Tool Mastery Series!
View full article
.NET Framework is a software framework developed by Microsoft that supports the building and running of apps and XML web services. The framework version can have an impact on the installation and operation of Alteryx.
View full article
A common concern in predictive modeling is whether a model has been overfit. In statistics, overfitting  refers to the phenomena when an analytical model corresponds too closely (or exactly) to a specific data set, and therefore may fail when applied to additional data or future observations. One common method that can be used to mitigate overfitting is regularization .  Regularization places controls on how large the coefficients of the predictor variables grow.  In Alteryx, the option of implementing regularized regression is available for the  Linear Regression  and Logistic Regression  Tools.
View full article
Alteryx has the ability to create and query Pre and Post SQL statements. Using this feature is good if you need to create a temporary table, delete or update the table before running the select. With this, you also have the ability to run stored procedures (via exec stored_procedure;) before and after the actual query as well.
View full article
The subtitle to this article should be  a short novel on configuring the Decision Tree Tool in Alteryx . The initial configuration of the tool is very simple, but it you chose to customize the configuration of the tool at all, it can get complicated quickly.  In this article, I am focusing on the configuration of the Tool. However, because it is a Tool Mastery, I am covering everything within the configuration of the tool
View full article
This article describes and explains the outputs of the Decision Tree Tool.
View full article
The Analytics Gallery What is an Analytic Application? Pre-packaged data and analytic integration published to the Alteryx Analytics Gallery by Data Artisans to answer specific strategic analytics questions.   What is the Analytics Gallery? The Analytics Gallery is a publicly hosted web service where applications can be published, securely shared, and run in the cloud.   What is a Viewer? A Viewer is a free user of the Analytics Gallery. A Viewer can run all applications published in the Public Gallery.   What is a Member? A Member is a user who can run applications that are shared privately through Collections. A Membership is granted by a Data Artisan. A Member also shares the privileges of a Viewer to run all applications published in the Public Gallery.   What is a Data Artisan? A Data Artisan is a user who creates analytic applications using the Alteryx Designer Desktop and then shares them publicly and/or privately in the Analytics Gallery. A Data Artisan also shares the privileges of a Member.   What is required to run applications in the Public Gallery? Anyone can sign up and become a Viewer, with the ability to run all applications in the Public Gallery, for free. As soon as you confirm your email, you will have access to the Public Gallery.   What is required to run an application in a private Collection? You must be a Member to run applications shared in private Collections. Memberships are granted by Data Artisans, who create and share applications.   What is required to build applications? Applications are built with Alteryx Designer Desktop. Download the Designer Desktop Free Trial.   What is required to publish applications in the Analytics Gallery?  Applications are published from the Alteryx Designer Desktop into a private Studio. •A Studio is automatically created for license holders of the Designer Desktop. •Trial users of the Designer Desktop can set up a Studio with a 30-Day Studio Free Trial    A user with the Designer Desktop and a private Studio is known as a Data Artisan.   How do I run an application? 1. Click on the title of an application to view application details and click the Run button; or simply click the icon. 2. Configure the application to suit your needs. Depending upon the application, you might be prompted to enter an address for geocoding, to input a customer file for demographic analysis, or to select data from a range of choices that apply to your business. 3. Click the Run button at the bottom of the application.   What are the results of running an application? Applications can be authored to create a variety of different reports and data outputs. When the application processing finishes, the results will appear in the same window as the questions you answered before running the application.   Reports can be previewed after an application has completed by clicking on the Preview link.   Additionally, results for applications that have been run can be found in the application detail view, and the "App Results" tab on the left of the screen.   What kinds of reports can an application create? Depending upon how the application was built, it may produce Word, Excel, HTML, and/ or PDF files, containing a variety of text, tables, charts and maps.   What kinds of tabular and spatial data output can an application create? Depending upon how the application was built, it may produce CSV, MDB/ ACCDB, DBF, FlatFile, MID/ MIF, SHP, TAB, YXDB, and/or KML files.   I ran an application but I closed the window before it finished running. How can I view the results?  Application results are stored with your account and can be accessed at any time. As long as you are signed in, the results of any applications that have finished running can be found in two places: •Under the application details page for an application. •Under "App Results" (visible on the left side of the screen when you are signed in).     How can I view more details about an application? Click on the name of an application to view details, such as the upload date, description, author, studio, copyright, and number of times run. The application details page also includes buttons enabling you to Run, Share, and (if enabled) Download the application.   What browsers are supported by the Analytics Gallery? We always test and support the latest versions of the most popular web browsers.  For more detail about specific browser versions see ‘System Requirements’ of the Technical Specifications page.     How can I find the applications I need?  Each section of the Analytics Gallery features a context-sensitive Search field you can use to find applications. •Searching in the Public Gallery returns applications in the Public Gallery. •Searching in the Studio tab returns applications in your Studio. •Searching in a Collection returns applications in the Collection. •Additionally, a Collection created by you will offer a second search window, which allows you to find applications in your Studio and add them to your Collection.   Publishing and Sharing Applications  What is a Studio? A Studio contains all of the applications published by the Data Artisans within an organization.   Who has access to the applications published in a Studio? All of the Data Artisans within an organization, and only those Data Artisans, can view and run any applications in their Studio.   How can I rename my Studio? 1.Click on your User Name to go to your Settings. 2.Select the Studio Tab. 3.Enter a new name in the Studio Name field. 4.Click the save button.   How can an application be shared? 1.When an application is published in a Studio, all Data Artisans belonging to that Studio can access it. 2.An application in a Studio can also be shared to the Public Gallery, where anyone can access it. 3.An application in a Studio can also be shared in a Collection. Any users added to the Collection can access it.   As a Data Artisan, how can I share an application privately with someone? 1.Publish an application from the Designer Desktop to your private Studio. 2.Add the application to a Collection. 3.Add the User to the Collection. In order to run the application, the user must be a Member.   As a Data Artisan, how do I grant a Membership to someone?   1.Click on your User Name to go to your Settings. 2.Select the Studio Tab. 3.In the Members section, enter an Email address or User Name.     As a Data Artisan, how can I tell how many Memberships I have to distribute? 1.Click on your User Name to go to your Settings. 2.Select the Studio Tab. 3.Find "Memberships available to distribute" in the Members section.   How can I purchase additional Memberships? Please contact Sales@Alteryx.com.   What applications can be added to a Collection?  Only applications published in the Data Artisan's Studio may be added to a Collection. Applications in the Data Artisan's Studio may also (at their discretion) be shared in the Public Gallery. However, applications in the Public Gallery that were published from other Studios cannot be added to a Collection.   Can an application be added to more than one Collection? Yes.   As a Data Artisan, do I also need a Membership? No, Data Artisans are also Members.   I am a Data Artisan or Member. I want to run an application shared with me from a different organization. Do I need a Membership from that organization? No. A single Analytics Gallery Membership entitles you to run private applications shared from any Collection.   As a Data Artisan, how can I add another Data Artisan to my Studio? Please contact support@alteryx.com for assistance.   My organization has more than one Data Artisan. Who controls the distribution of Memberships? At present, all Data Artisans have equal access to Membership distribution under Studio Settings.   What types of users can be added to a Collection? Data Artisans, Members, and Viewers can all be added to a Collection. You can even enter the email address of someone who has not yet visited the Analytics Gallery.   Can a Viewer who is added to a Collection run the applications in the Collection? Only those applications in the Collection that have also been shared in the Public Gallery by the Data Artisan can be run by the Viewer.   What types of users can run private applications in a Collection? If an application in a Collection has not been shared in the Public Gallery, Viewers (who have been invited to join the Collection) can view the application, but cannot run it. Only Data Artisans and Members can run the application.   How can I find users to add to a Collection?  Select the Collection and use the Search Users field on the right. Any registered users of the Analytics Gallery that match your search terms will be returned.   Additionally, you can add someone who has not registered with the Alteryx Analytics Gallery by entering a valid email address. An invitation will be sent.   Is there a limit to the number of applications or users I can add to a Collection? No.   When I add a new application to a Collection, are the users in that Collection notified? Yes.   Can I allow users within my Collection to share it with others? Each Collection includes a checkbox on the upper right that states "Other users may share this collection." When this box is checked, anyone in the Collection will have the ability to add other users to the Collection.   The Data Artisan who created the Collection will see the names of any additional users who are added to the Collection, and can remove them.   I published an application and shared it in a Collection (or in the Public Gallery). Since then, I have made changes to the application in the Designer Desktop. Can I update it? First, select the original version and delete it. Next, re-publish the application and add it to your Collection (or to the Public Gallery)   How can I share an application in the Public Gallery?  Click on the name of an application to view the application details page. Click the Sharing button and choose "Place in Public Gallery."   How can I remove an application from the Public Gallery?  Click on the name of an application to view the application details page. Click the Sharing button and choose "Remove from Public Gallery."   How can I share an application through email or social media?  (Public Gallery applications only) Click on the name of an application to view the application details page. Click the Sharing button to share via email, Twitter, Facebook, and Google+.   Publishing Restrictions  What is "private data?" A license of the Alteryx Designer Desktop may include a variety of private data sets, including demographic data, psychographic data, business list and consumer list.   Can I publish applications using private data? Yes, applications using private data can be published in your private Studio, and can be shared in Collections. They cannot be shared in the Public Gallery.   What data is allowed in the Public Gallery? Please see Alteryx Analytics Gallery Data Inventory   What capabilities in the Designer Desktop cannot be used in the Analytics Gallery?  The following tools are prohibited in applications published in the Analytics Gallery. •Run Command tool •Run Command event •R tool (Macros included in the Designer Desktop that use the R tool are permitted.) •Email tool •Send Email event •Download tool     I built an application that uses a prohibited tool in a safe manner. How can I apply for an exemption? 1.Email curator@alteryx.com and explain how and why each prohibited tool is used, along with the general purpose of the application. 2.Publish the application in your Private Studio and check the box "Others may download this application." 3.Add the application to a Collection and share it with curator@alteryx.com.   Your application will be reviewed and an exemption may be made to allow it to be run.   What tool configurations or question types cannot be used in the Analytics Gallery?•Input and output files referenced by Tools must be in the same directory as the application. •The application Question type "Folder Browse" cannot be used in applications published to the web. •In the application Question type "File Browse," the "Save As Dialog" configuration cannot be checked. •Application results (under analytic application properties) cannot include Browse tools.   Are there limits to the file size of applications and/or data published in the Analytics Gallery? Yes, applications and data are limited to 100MB.   What are my options if I want to publish an application and data that exeed 100MB? Please use the Cloud Connector tools within the Designer Desktop to host your data on the cloud.   Are chained applications supported in the Analytics Gallery? At present, chained applications are not supported.     General Assistance  I forgot my password. How can I reset it? Click Sign In and click the Forgot Password link. Enter the email address associated with your account and a new password will be emailed to you.   Can I download an application? Yes, many applications can be downloaded. View application details and click the Download button. Use the Alteryx Designer Desktop to open the *.YXZP files that are downloaded. Go to Designer Desktop Free Trial to get started if you're not already an Alteryx customer.   I need help with my account. Who should I contact? Please log a case at www.alteryx.com/community.   I found a bug on the Analytics Gallery or in an application. Who should I contact? Please log a case at www.alteryx.com/community.   How can I purchase additional Memberships, Data Artisan accounts, or extend my subscription? Please contact Sales@alteryx.com.   How can I recommend a feature for the Analytics Gallery? Please send your feedback to GalleryFeedback@alteryx.com.   Where can I connect with other Alteryx users to ask questions and learn about best practices? www.alteryx.com/community   Who is the better captain, Kirk or Picard? Malcolm Reynolds
View full article
  This is a quick guide to get you up and running with Alteryx!   Please note: To license Alteryx versions 11.7 or older, check out the Licensing Series here. If you’re a current customer, check out the 11.8 Licensing FAQ for more information on what’s changing with Licensing.   If you have other questions about licensing, let us know at fulfillment@alteryx.com!   What do I need to get licensed? Alteryx products require license keys to activate, which are 32-character strings split into dashes, ex. 1a2b-3c4d-56ef-7g89-0h12-jkl3-4m56-n78o Each license key corresponds to a single product, so you may have one key for Alteryx Designer and another license key for an add-on product, like US Data. Each license key has a number of seats available, which corresponds to the number of machines it may be used on. A single user may use multiple seats if they activate the license key on multiple computers. Alteryx will send license keys to a license administrator at your organization, who decides how to distribute these licenses. How do I license Alteryx? Licensing Alteryx is easy! Just follow these simple steps: If you need to download Alteryx, you can find it in the Downloads & Licenses portal at licenses.alteryx.com. You will need your license key to sign in to the portal. Install Alteryx on your computer, and open it. When prompted, type in your email and paste in your license keys. You can input multiple license keys at the same time, one per line, if you have multiple licenses to activate. If you’re already licensed, you can get to this screen in Designer by going to “Options”, “Manage Licenses”, and then “Activate New License”. That’s it! What if I’m offline? If you’re offline, you’ll need to activate Alteryx using license files. Open Alteryx to the below screen: This is the offline activation screen, so you need to be disconnected from the internet for it to appear. If you’re already licensed, you can get to this screen in Designer by going to “Options”, “Manage Licenses”, and then “Activate New License”. Click on the “Create” button and paste in your license keys, email, first name and last name. Then, click “Create request” to generate a *.req file and save it on your computer. Take this file and upload it to licenses.alteryx.com, or provide it to your license administrator. Click “Upload Activation Request” under the Announcements to upload. Download and save the *.bin file to your computer. Back in Alteryx, now click on the “Browse” button under “Use an activation file to activate offline”. If the previous window is still open, you can click “Back” to go back to the activation screen.   What do I need to know if I'm a License Admin?   License admins play an important role in getting their colleagues up and running in Alteryx. All new license keys get sent to the License Admin, who decides how to distribute them in the company.   Here’s how it usually works: Alteryx sends an email over to the license admin (above) with the license keys and other information. The license administrator sends the license keys over to Alteryx users at their company, along with a link to licenses.alteryx.com, where they can go to download Alteryx software and datasets. License admins also have access to extra functionality on the Downloads & Licenses  portal at  licenses.alteryx.com!   Can I deploy Alteryx in a silent install? Absolutely! If you would like to automate the deployment of Alteryx, you can use our command line activation options to install and license Alteryx software in the form of a script or packaged app deployment.   What are the technical requirements? First, check that you meet the technical specifications for installing and running Alteryx. Make sure that Port 80 and Port 443 are open. The licensing system contacts the following web domains, so make sure that the computer has access to them: alteryx.com NB: Alteryx Designer must be able to connect directly to https://fno.devops.alteryx.com. If your network employs a transparent SSL/TLS proxy to intercept and inspect encrypted payloads, you will need to request an exemption (sometimes called a "decrypt bypass") from your IT/security team. marketo.net mktoresp.com alteryx.flexnetoperations.com   UPDATE: As of 3/14/18, the URL "downloads.alteryx.com" will re-route to "licenses.alteryx.com".  To access the Downloads and Licenses portal, please sign in, and select the product you'd like to download, such as Designer, from the homepage.   Previous versions of your selected product can be downloaded on the following screen; toggle between "New Versions" for the latest version and "Previous Versions" for earlier, supported versions of the product.   
View full article
Alteryx has recently released (Mar 2018) a new Google Analytics Connector. You can download it here.    Here is an overview of the new GA tool in Alteryx Designer 11.0:     Connecting to Google Analytics is becoming more and more popular and There are a few things you need in order to use the Google Analytics macro: A Google Account (e.g., Gmail) Authorized Access to an existing Google Analytics account   Step 1: Set up a Google Analytics account   Please visit the Google Analytics webpage and sign in https://www.google.com/analytics/     On the landing page for Google Analytics you will need to add the Account Name, Website Name and website URL. Once you have entered this information you can click ‘Get Tracking ID’ and this will generate a Tracking Code for the website you would like to attain information on. Once you have generated this code this will take you to Google Analytics Home Page. Creating the Tracking ID creates a Profile ID and/or View ID with the associated website URLs which are used in the back end in the Google Analytics Macro within Alteryx. If you would like to find this information please click on the Admin tab on the Google Analytics home page and navigate to the ‘Property Settings' and 'View settings' to see the Tracking ID and Profile ID/View ID respectively.       Step 2: Now it is time to set up the Client ID, Client Secret, and Refresh Token needed for the Google Analytics Macro:   Go to the Google developers page: https://developers.google.com/  You will now need to navigate to the 'Google API Console' (This can be found at the bottom of the developers.google.com page).    Once on this page you can click on the 'Analytics API' link      When on the landing page for the Analytics API please press the ‘Enable’ button. Once this is enabled the button should change to ‘Disable’.    Congratulations!  You have registered your application by creating a project.     Step 3: Generate your Client ID and Client Secret Within the API Manager you should see a 'Create credentials' option. Click ‘OAuth Client ID’ when the drop down menu appears.    On the next page make sure the Application type selection is Web application   This will generate additional required information below. You can leave the Name as Web Client 1, but please change the Authorized redirect URIs (second option under restrictions) to: https://developers.google.com/oauthplayground Hit Create and wait a few seconds for Google to create your new project.   Acquire your Refresh Token In another tab in your Web Browser please navigate to Google’s OAuth Playground https://developers.google.com/oauthplayground Once on the landing page firs click the cog icon button near the upper-right corner of your monitor Check the box Use your own OAuth credentials and make sure Access type is set to Offline Paste in your Client ID in the ‘OAuth Client ID’ field Paste in your Client Secret in the ‘OAuth Client Secret’ field Hit Close In the sidebar on the left, scroll down to the Google Analytics API v3 under Step 1 Select & authorize APIs Click the little grey triangle on the left and select https://www.googleapis.com/auth/analytics.readonly Hit Authorize APIs (you will be directed to another page) When prompted, hit Allow. You will be redirected back to the OAuth 2.0 Playground. Once you’ve been redirected back to the OAuth 2.0 Playground hit the Exchange authorization code for tokens button.         Your Refresh Token will be contained in a JSON object towards the bottom of the Request / Response section. You can copy this string and save in the same location as your CLient ID and Client Secret.   Congratulations!! You now have all the pieces you need to use the Alteryx Google Analytics Connector!!   Step 4: Lets move to Alteryx! The Google Analytics macro can be downloaded here and found in the Connectors tab Once you have the macro on the canvas you will have two login options: Online Login: This will take you to your Google Login and will automatically create a Client ID, Secret & Refresh Token Offline Login: This will allow you to enter in your Client ID, Secret and Token. This process is recommended for those scheduling the GA tool.    Once logged in you will be prompted to select an available Account; WebProperties; Profiles. Each configuration window will prompt you to press Next to move to the next screen. The GA tool will allow you to select the Date, Metrics & Goals, Dimensions & Segments and give you a summary view to show you selections Once you see this summary press run and you will now see your data.   Tips and Tricks Check out the S datastream output – it contains summary information with each run, and in this case shows all of the account/property/view combinations that are associated with the credentials and loaded in. The D stream will show the data from Google Analytics. When querying custom metrics, dimensions, or segments, you can only be allowed to select a certain combination. The GA tool will notify you of this. Every query requires you to select a profile, at least one metric, and a date range. Everything else is optional.   Click on Spoiler to see all error messages and troubleshooting tips!   Common Issues (Prior to Version 3)   The Refresh token lasts about 1 hour so please remember to refresh the token as this will prompt errors.   Please repeat Step 4 above to refresh the token. Remember to add your Client ID and Secret into the oauth credentials before Authorizing the API!   ‘The Field ‘id’ is not contained in the record…’ (Upgrade to the latest GA tool) This error message can allude to a number of issues. However, to limit trial and error I have prioritized the solutions below based on prior troubleshooting experience (I know im awesome).    1) Please request 'Full control' or as minimum 'read & write' permissions to the supporting macros folder. For Admin installs this folder can be found in: C:\Program Files\Alteryx\bin\RuntimeData\Macros\Supporting_Macros (Relative to where you installed Alteryx).  For Non-Admin installs this folder can be found in: C:\Users\{USERNAME]\AppData\Local\Alteryx\bin\RuntimeData\Macros\Supporting_Macros (relative to your user name) (App data is a hidden folder so you may need to turn hidden folder on)  The reason is outlined in more detail below, but in short, the GA connector reads & writes files necessary for the API connection in these locations. If we do not have write permissions the API connection will fail and give us the error above.  ****DISCLAIMER - YOU WILL NEED TO GET YOUR IT PERMISSION TO DO THIS. Unless you have admin rights to your machine.  2) Your refresh token has expired Please follow Step 4 above and remember to add your Client Secret and ID into the Oauth credentials section on the right hand side before Authorizing the API.  3)  Are you inside your company firewall? If you have tried the above solutions and neither of them worked please try outside of your company firewall (With your IT departments blessings of course)  I have not seen many instances of this but this did resolve the issue in a few cases.        ‘Tool #349: Tool #4 Error Transferring data: Failure when receiving data from the peer’ (Upgrade to the latest GA tool)   Check Profile ID This can also be firewall issues, check with IT if they are blocking transaction from Google Analytics to the user.     ‘Tool #574: Tool #522: Error creating the file "C:\Program Files|Alteryx\bin\RuntimeData\Macros\Supporting_Macros|GoogleAnalytics.DIMENSIONS.xml": Access is denied.’ (Upgrade to the latest GA tool) ‘Tool #574: Tool #706: Error creating the file "C:\Program Files|Alteryx\bin\RuntimeData\Macros\Supporting_Macros|GoogleAnalytics.PROFILES.xml": Access is denied.’ (Upgrade to the latest GA tool)   The Google Analytics macro is dependent upon deleting and updating four files within Program Files. These four XML files are the Profiles, Dimensions, Segments and Metrics. Currently a command line window flashes for a second at the start of running in Update mode – this is to circumvent an access limitation (because the installation files are located in Program Files, they cannot be overwritten – but they can be deleted and written anew). This allows the metrics, dimensions, and segments XML files to be updated.   Sometimes due to internal setting these files cannot be accessed and you may get an error saying ‘Access Denied’ (error referenced above). If this is true you can contact your IT to give you permissions to this file location. Alternatively you can run Alteryx as Administrator and this may give you the elevated Admin privileges to right to this Location from Alteryx (Right click on the Alteryx Icon and ‘Run as Administrator’.     ‘You have set up the Google Analytics Connector Tool and want to know the # of records is produced in the data output? ‘ (Upgrade to the latest GA tool)   The macro aggregates the data across the entire time period, and is grouped by dimension. If you don’t choose any segments in the query, then there will be one row. If segments are selected, then you’ll get multiple rows back for each possible value of dimensions. If you want to retrieve one record per day, the best way really is to setup a little batch or iterative macro to loop through a collection of dates.     ‘You have got a Client ID, Client Secret and a Refresh Token however you do not return any results. ‘ (Upgrade to the latest GA tool) Make sure you have installed a Google Tracking Code on the target website. If not this is something the web developer would have to do. For more information please look here: https://support.google.com/analytics/answer/1008080?hl=en     ‘Receiving a createRecord: A record was created with no field’s error.’ (Upgrade to the latest GA tool) Try right clicking on the Alteryx Designer Icon and ‘Run as Administrator’. This can give elevated permissions to access the dimensions, Profiles and Metrics in Program Files.     ‘Unknown Variable’ (Upgrade to the latest GA tool)   This error will appear when youe enter in the Client ID, Secret and Refresh Token. Do not fear, just configure the search tab and this error will be removed once you run the GA connector.  Please refer back through the steps above as you have more than likely missed a step in the configuration. This error has appeared when the ‘Analytics API’ has not been enabled.     Could not find file…’ (Upgrade to the latest GA tool)     Please check the ‘Reset to default’ option and run the Google Analytics Connector. This will re-write the four XML file into Program Files.     CONGRATS you have now made it through the worlds longest but most informative Google Analytics Article (in my opinion).   Now go free and play with your Google Analytics Data in Alteryx!      However, if you continue to have problems with the Google Analytics connector please reach out to Alteryx Support     Best,   Jordan Barker Client Service Representative
View full article
One common reason why the Alteryx Service appears stuck in the 'Stopping' state is when the service is trying to stop but the AlteryxEngineCmd.exe process is running. In other words, a workflow is running. The Alteryx Service cannot be stopped when a workflow is running due to a schedule or a Gallery run.
View full article
The Find Replace Tool is one of those tools that goes relatively unused and uncelebrated until you stumble into a data blending technique that would be extremely difficult without it – at which point, it becomes your favorite tool in the Designer. You can find it in the Join Category and it’ll make easy string substitutions in your data that would otherwise require herculean effort to work around. Today, we celebrate Find Replace as a hero.
View full article
In developing workflows our users need to push workflows to server or scheduler that contain database connections.  This is a common source of errors if not configured properly.
View full article
What does this error mean?     As we transitioned to a new licensing system in the 11.8 and 2018.1 releases, we changed how licenses are authenticated. The new licensing system relies on a few additional system requirements, including a number of websites that are used during licensing and require access through your network firewall.   What's causing this? The new licensing system uses a TLS connection with fno.devops.alteryx.com, which is secured with an Amazon-issued TLS/SSL certificate. Alteryx is packaged with a copy of the Amazon certificate. The problem arises when the network has implemented Deep Packet Inspection on TLS/SSL connections, which is a security measure requiring that a network device be able to intercept the connection and “see” the plaintext conversation. To do this, the device attempts to impersonate fno.devops.alteryx.com but uses its own certificate, which is separately installed as a trusted root certificate on the client computer. However, Alteryx doesn't consult the local computer's trust store when authenticating the license connection. Thus, when Alteryx attempts to construct a TLS session, it sees a certificate mismatch, and the connection fails.   The "quick-fix" Since this is a network security restriction, you should have no problem activating if you move onto an external network such as a mobile hotspot, home network connection, or coffee shop.   Troubleshooting   How to confirm the problem   To definitively confirm that they are running into this issue, have them open a browser and go to https://fno.devops.alteryx.com. It will show a blank screen, but up in the corner is certificate information. Click on the lock to view the certificate details.           This window needs to show this exact certification Path. If there are any extra or different entries, that's when this issue occurs.   How to fix it?   IT or your security department need to add a bypass on the SSL packet inspector such that https://fno.devops.alteryx.com is not subject to SSL deep packet inspection. After adding the bypass so this traffic is no longer being interdicted, the issue should be resolved and the customer should try to activate again.
View full article
Database aliases can help users save time and allow easier sharing of data. Let's take a look at how.   The first step to creating a database alias in Designer is to establish the database connection. This can be done with the Input Data tool by selecting any of the database options in the dropdown.   Databases we can connect to with Alteryx, an overview. http://www.alteryx.com/technical-specifications   Once you’ve established the connection through the connection admin, a database connection string will appear, like the one shown below.     Next, let’s go to the Manage Database Connections window (or Manage In-DB Connections window for In-DB aliases). This will be under Options > Advanced Options > Manage Data Connections. Here we can add new aliases, and edit or delete, any existing ones.   Manage Database Connections overview: There are two types of aliases: User: Any user can add a User Alias that only they will be able to access and change. System: System Aliases can only be added/edited by a local administrator.   Available options: Sync All allows you to sync Gallery Data Connections Add Connections allows you to create a new alias (see steps below)   Additional options can be found when you hover over an existing data connection: Allows you to edit the password of the Alias.    Allows you to delete an alias         When adding a new alias, Alteryx will assist you in making the connection to both MS Sql Server, and Oracle. For all other database connections, select the 'Other' option.   There will be three things to include for 'Other' database connection types: the connection type (user vs system), an alias name and the connection string. The reason we made the connection first through the Input data tool is so that we can simply copy/paste that string into our alias manager.   When the alias has been created you can access this connection through the Input Data tool dropdown under Saved Data Connections. You’ll notice that the string now says aka:AliasName.     Advantages: Q: What happens when you have multiple workflows that all reference a connection string and your password changes?   A: If using workflows that reference an alias, the user will only have to update the password in the alias manager. If using a regular connection string, every Input Data tool will have to be updated in every workflow that uses that connection.   Q: Can I share, or export, a workflow that has database connection strings?   A: Yes! If you setup an alias on both user’s machines that are an exact match you will be able to share workflows that use those database connections.   Note:   The screenshots and steps taken to create the database connection and alias were built in Designer version 11.8.   Tony Moses Customer Support  
View full article
Tab 1 - Basic URL : The URL for the resource you are trying to access must come from an upstream tool and is the only field required by Alteryx to configure the Download tool. Based on the API you are trying to pull information from (or send data to), other information will be required such as headers and/or a payload.
View full article
The cause and solution to the "DisableAllOutputForLicense" error with the Predictive Tools.
View full article