Top 10 Data Preparation Tools Revolutionizing the Analytics Landscape in 2023
Competitive businesses must prioritize proper data preparation techniques and analysis tools to stay competitive. The adage “garbage in, garbage out” gains more...
- Jeffrey Agadumo
- June 2, 2023
Alteryx Acquires Trifacta
Alteryx announced that it is acquiring Trifacta, a provider of data preparation software. The acquisition supplements the Alteryx product family, particularly for cloud/Sa...
- John Morrell
- January 12, 2022
Why is my Alteryx formula returning 0’s when I try to replace null values with the average?
In this article, let’s learn why Alteryx formula returning 0’s when replaced null values with average. While there are many ways of handling null values in an ETL pro...
- How-Tos FAQs
- August 1, 2021
How to perform a SQL query in Alteryx
In the following article, we will look at how to perform an SQL query in Alteryx. SQL is the standard language to execute queries on a relational database that are not stor...
- How-Tos FAQs
- July 25, 2021
Can you run an Alteryx workflow from the command line?
Yes, you can run an Alteryx workflow from the command line. This is less expensive than Alteryx Server as it does not require a license that enables API & Command Line ...
- How-Tos FAQs
- July 15, 2021
What are Alteryx YXDB Files
Let’s take a look at what Alteryx YXDB files are and how they are unique to the Alteryx tool. Alteryx has been unofficially crowned a speed demon in all that it can d...
- How-Tos FAQs
- July 15, 2021
How to prevent a different output from the Alteryx R tool
How to prevent a different output from the Alteryx R tool In this article, we will discuss some of the leading causes of incorrect different output when you use Alteryx R T...
- How-Tos FAQs
- July 8, 2021
How to create a Pivot Table in Alteryx
Pivot tables are a very useful tool in Microsoft Excel used to group and summarize data of a more extensive table within one or more discrete categories. This summary might...
- How-Tos FAQs
- March 23, 2021
How to check if values from one field exists in a different field in Alteryx
Let’s explore how to check if values from one field exists in a different field in Alteryx. During ETL process is common to have the need to scan two different fields...
- How-Tos FAQs
- March 16, 2021
Resolve duplicate column names in excel file with Alteryx
Let’s explore how to resolve duplicate column names in an excel file with Alteryx. As we work with databases it is common, especially if we work on Microsoft Excel, t...
- How-Tos FAQs
- March 16, 2021
How to create a date combining different fields in Alteryx
Let’s take a look at how to create a date combining different fields in Alteryx. It is very common to handle databases that have date fields split into several column...
- How-Tos FAQs
- March 16, 2021
How to Parse fields using RegEx in Alteryx
While we are analyzing or extracting data from a database, it is often helpful to exploit regular expressions to parse data from a specific field. In Alteryx, there is a ...
- How-Tos FAQs
- March 8, 2021
