• home

  • posts

  • contact

  • More

    Use tab to navigate through the menu items.

    SUBSCRIBE

    • All Posts
    • alteryx
    • microsoft office
    • tableau
    Simple REST API JSON Example
    • Mar 2
    • 2 min

    Simple REST API JSON Example

    Have you heard of pulling data from API? In a previous Tableau blog post here, I am taking a course on API. Wikipedia defines API as "An...
    133 views
    Using the Find Replace Tool Instead of a Left Outer Join
    • Feb 11
    • 2 min

    Using the Find Replace Tool Instead of a Left Outer Join

    Did you know that sometimes it is faster to use a Find Replace Tool instead of using a Join Tool with a Union Tool for a Left Outer Join...
    71 views
    Writing Out to Multiple Excel Tabs or Multiple Excel Spreadsheets
    • Jan 20
    • 2 min

    Writing Out to Multiple Excel Tabs or Multiple Excel Spreadsheets

    What if you client wants to have separate tabs for different months in the same excel spreadsheet? What if they want them in different...
    166 views
    Multi-Row Formula Tool - Calculating a Moving 12 Months
    • Jan 13
    • 2 min

    Multi-Row Formula Tool - Calculating a Moving 12 Months

    Do you need to calculate a total value for the last 12 months? If you have data from January - December, you can use the Summarize Tool...
    128 views
    Find Replace Tool with Comic Book Characters
    • Dec 10, 2021
    • 2 min

    Find Replace Tool with Comic Book Characters

    Do you have part of a phrase in a column and you just need to replace one word? What if you wanted to add another word in that same cell?...
    46 views
    Add a Hyperlink in Alteryx
    • Dec 2, 2021
    • 2 min

    Add a Hyperlink in Alteryx

    Did you know you can add a hyperlink to your dataset in Alteryx? This tip was suggested by Nicolas Colombo. Thank you Nicolas! This...
    79 views
    Bingo Cards in Alteryx
    • Nov 18, 2021
    • 1 min

    Bingo Cards in Alteryx

    Have you ever wondered how to generate Bingo cards? For an upcoming wedding there are various bingo activities such as meet the guest. ...
    61 views
    Forgot to Annotate?
    • Oct 28, 2021
    • 1 min

    Forgot to Annotate?

    Do you have a workflow with a lot of different tools, say 100+? What if you forgot to document some of these tools for controls purposes?...
    58 views
    Where Have All the Formulas Gone?
    • Oct 19, 2021
    • 2 min

    Where Have All the Formulas Gone?

    Do you need to create a calculated field and you aren't sure which formula to use? Did you know that Alteryx lists all of the available...
    70 views
    Optimize Your Workflow
    • Oct 8, 2021
    • 1 min

    Optimize Your Workflow

    Do you want to make your workflow run faster? Below are a couple of tips to optimize the performance of your workflow. Did you know that...
    92 views
    Sample Tool vs Random Sample Tool
    • Sep 24, 2021
    • 2 min

    Sample Tool vs Random Sample Tool

    Do you need to pull a sample of data from a large dataset to validate formulas? Here are two tools in Alteryx that can pull from your...
    24 views
    A Few Helpful Alteryx Formulas
    • Sep 9, 2021
    • 1 min

    A Few Helpful Alteryx Formulas

    There are so many different Formulas (or Functions as found in this helpful reference article here.) in Alteryx. Below are just a few...
    189 views
    How to Add Grand Totals to Your Data
    • Sep 2, 2021
    • 2 min

    How to Add Grand Totals to Your Data

    Have you ever wondered how to add Subtotals and Grand totals to your data set? Here is one method; In this example I start out with the...
    280 views
    The Directory Tool
    • Aug 27, 2021
    • 2 min

    The Directory Tool

    Have you ever wondered why you would use the Directory Tool? This tool provides a listing of all the files in a specific directory (or...
    84 views
    What is the Fuzzy Match Tool?
    • Aug 5, 2021
    • 2 min

    What is the Fuzzy Match Tool?

    Have you ever wondered what this complex tool does? It can help to identify non-identical duplicates in a column. What are...
    72 views
    What's the Difference Between the Append, Join and Union Tools?
    • Jul 29, 2021
    • 2 min

    What's the Difference Between the Append, Join and Union Tools?

    When I teach Alteryx to new users, this is a question that comes up a lot. I modified the below picture from the internet to help...
    39 views
    Using the Render Tool to Export to Different Sheets in the Same Workbook
    • Jul 23, 2021
    • 2 min

    Using the Render Tool to Export to Different Sheets in the Same Workbook

    As a follow up to last week's tech tip, I was asked how do you export to different worksheets in the same Excel workbook using the Render...
    564 views
    Write a Document to SharePoint Library Using the Render Tool
    • Jul 15, 2021
    • 1 min

    Write a Document to SharePoint Library Using the Render Tool

    I get questions all the time about Alteryx and SharePoint. I just learned this trick. You can use the Render Tool to write out to a...
    83 views
    Block Until Done Tool
    • Jul 6, 2021
    • 1 min

    Block Until Done Tool

    Have you ever tried to open an excel spreadsheet and received a message that another user is in the workbook? Every time an excel...
    42 views
    Forgot to Save? No problem!
    • Jun 15, 2021
    • 1 min

    Forgot to Save? No problem!

    Did your computer shut down and you forgot to save the workflow you were working on? Did you know that similar to Microsoft Office...
    55 views
    1
    2

    Subscribe to Tips

    If you find my tips useful, please subscribe.

    Thanks for submitting!

    • Twitter
    • Facebook
    • Linkedin

    © 2023 by BrainStorm. Proudly created with Wix.com