Hi everybody,
Here's my problem : I always need to check that the data files (.csv) sent by my client has a valid structure (number of columns, data type, mandatory values, max field value length, etc...) before applying my data blending workflow.
Today, this validation process is done semi-automatically with Alteryx by forcing the data types with a SELECT tool (and analyzing warnings in the log), by testing each max field length, or by using multiple formula tools for complex test.
I have a dream : A macro with 2 input :
- The data to check
- The expected structure (field type, min & max length, null value authorized)
and 1 output
- The full errors list (why not a table with only the values that does'nt match with the expected structure) with, ideally, the cause of the error
This kind of macro would be SOOOO useful !!! It's a really casual problem I encounter :)
I really don't know how to build this king of macro... could you please help me ?
Have fun !
Julien
