In a large enterprise - one of the key challenges is cleaning data in a consistent way. Many of the big EIM stacks have tooling for this which allows end users to create data cleanup rules, and the Microsoft version is called DQS (Data Quality Services).
Can we please add a connector to alteryx to allow us to drop a DQS cleaning tool onto a canvas - and then the 3 outputs will be
- data cleaned by DQS rules (managed by the data steward)
- error data that is invalid
- any status messages from the DQS call?
This would allow Line of Business users to build their own data cleaning rules consistently in one place, an lift this burden from the data analyst.
Thank you
Sean