Datameer Blog

Tag: Alteryx

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
alteryx FAQ

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
alteryx FAQ

How to perform an 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
alteryx FAQ

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
alteryx FAQ

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
alteryx FAQ

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
alteryx FAQ

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
alteryx FAQ

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
alteryx FAQ

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
alteryx FAQ

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
alteryx FAQ

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 de...

  • How-Tos FAQs
  • March 8, 2021
alteryx FAQ

How to impute a value for missing data in Alteryx

It is common to find null or missing values within the databases during the ETL process. Null or missing values are cells containing no values. These can dirty calculations...

  • How-Tos FAQs
  • March 3, 2021