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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

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