Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Data QA

Ojay
8 - Asteroid

I'm trying to put together an Alteryx workflow which I can use on a regular basis which can serve as a standard for the QA of data contained in Excel files rather than carrying out the QA in Excel before transferring over to Alteryx.

 

Any help with this will be appreciated.

 

Thanks.

 

Olu

16 REPLIES 16
Ojay
8 - Asteroid

@Thableaus: When I connect my data, the output of the dates come out as false in the match_date_format field. The dates are fine in Excel. Please help me understand.

Thableaus
17 - Castor
17 - Castor

@Ojay 

 

I'd need to see a sample of your data to understand what's going on.

 

RegEX will not work for every situation, you need to understand data and patterns.

 

Cheers,

Ojay
8 - Asteroid
@Thableaus: Can we connect privately?
Thableaus
17 - Castor
17 - Castor

@Ojay 

 

Try to send me a PM.

 

If you click on my profile, you will be able to see this option.

 

Cheers,

Ojay
8 - Asteroid

@Thableaus: Apparently I don't have the permission to message you privately. I don't know why.

Ojay
8 - Asteroid

@Thableaus: Are you on Twitter?

Thableaus
17 - Castor
17 - Castor

Hi @Ojay 

 

Contact me over Hangouts: engmatdoni@gmail.com

 

Cheers,

Labels