This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
You may already know how to use the MIN() and MAX() functions to find the smallest and largest values in a list. But what if you needed the second smallest number or 3rd largest number in the list?
Excel has a function for this. Using the =SMALL function, you would specify the data range followed by 'x' smallest number you want to find.
This issue appears when an App writes to an Excel document. When the results are displayed and the Excel document opened, it will show as empty. As soon as the Excel document is closed, an Unhandled exception error will display, and the App cannot be closed.
You're working on your gazillionth Formula tool and "Jeff" from Quality Assurance sends you an email that the margin of error for your process has been restandardized. It's not 0.122 anymore but 0.121. Then the horrible reality sets in - you're going to have to go back through all of your formulas and update that one.. stupid.. little.. number.
Sometimes clients have asked how they can re-input the same excel file that they have just outputted into the same workflow. Normally, their gut instinct would be to open up a new workflow and start fresh with the updated file. However, this can be a bit cumbersome especially if they want to do this multiple times or for those wanting to do some sort of logging process in an app. Luckily, there is a quick and easy trick for this.
For any macro or analytic app – one of the inevitable questions that you may encounter is “how do I configure this to do what I need?” For example, if you build a macro that checks if two fields are equal, but sometimes you want to ignore the case such that “A” equals “a,” and sometimes you want an exact match. This is where the Interface Tool Category comes to the rescue, with a super-tool called Check Box!
This article is part of the Tool Mastery Series, a compilation of Knowledge Base contributions to introduce diverse working examples for Designer Tools. Here we’ll delve into uses of the Date Tool on our way to mastering the Alteryx Designer
When setting up manually specified NAME and VALUE parameters in an Alteryx Analytic App there are two options. When the NAME and VALUE are different, they must be in the format “Name: Value”. However, if the name and value are the same, you can just type the Name (or Value, they are the same either way).
The Drop Down list would look like this:
Alteryx users who have purchased the TomTom Alteryx Maps data set have the ability to extract layers into various formats using the Alteryx Street Analytic App. Installs from TomTom 2011 Q3 Alteryx Maps forward, include the Street App within the install. The App replaces what was previously known as the StreetWare product. The Alteryx Street App is an extraction tool which allows the user to extract TomTom layers into various file formats such as .tab, .shp, .yxdb to name a few. The App is specific to the data install vintage of TomTom Alteryx Maps Data and is located in the, AlteryxDataProductsAlteryxMapTomTom_US_xxxx_Qx directory. To run the Street App (TomTom_US_yyyy_Qx.yxwz) you will need to browse to the location above and select it. Under the Geography Selection tab, select the Geographies you would like data for. You may select all, single or multiple Geographies as shown below:
Under the Layer Selection tab, you may select the individual layers you would like to install for the Geographies that you selected.
The Output Options tab allows you to select the file format you wish to create and the Destination directory you wish to install the data to. There is also an option to merge the geographies.
One feature of the wizard that was not present in the StreetWare product is the ability to create seamless .tab files. This feature allows the user the ability to bypass the 2 GB limitation that .tab files have. Please note .shp files also have a 2 GB file size limitation but do not offer the same seamless ability that is incorporate in the extraction of .tab files When .tab file format is selected a folder is created containing the referenced .tab tables, the seamless .tab files are visible below this folder. As Shown Below:
The seamless .tab files will be opened and viewed in MapInfo as normal. The individual .tab files that are referenced by the Seamless files can be found in the SeamlessTabFiles folder. We hope our users find that the Street App will be an easy-to-use utility to extract the desired map layers for use in their preferred applications.