community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Data QA checks and handling

Asteroid

Hi Family,

 

I'm trying to create a workflow that can do the following for my data:

 

  • Data Quality Assurance: Checking for accuracy - Completeness (i.e. Rate of missing and "null" values); and Correctness (i.e. invalid codes, duplicates. invalid dates, out of range, outliers, and extreme observations)
  • Data Cleansing / Preparation: Handling missing and "null" values, invalid codes, invalid dates, out of range, outliers, and extreme observations.

The data involved is from multiple sheet excel files with a few common columns but different schema.

 

Thanks for your help in advance.

Asteroid

Hi @Ojay,

 

I would suggest looking at the following tools:

 

- Field Summary

- FIeld Info

- Basic Data Profile

- Data Cleansing

- Auto Field

- Imputation (handle missing/nulls)

 

Asteroid

@al_sweets: i'm still on it.

Highlighted
Meteor

Hi Ojay,

 

In addition to the tools mentioned by @al_sweets ; also look at the "Test" tool in the developer group.

This will allow you to build tests to automate your validation.

 

 

Asteroid

Any chance of a suitable workflow that can be used in this instance?

Labels