Input Data Errors

tom_dup_567

Being new to Alteryx I have noticed that during the input process of CSV files I get warnings such as "An unescaped quote was found" with the record  number identified.  In my data this occurs because in some fields there are entries such as 24" (24 inches).  I use the Formula tool and a Replace function to deal with the rouge quote during the workflow.  My question is on the initial error, is there a way to resolve the error so that I know that the data moving through the workflow is getting cleaned? For instance, is there a way to create like a pre-sub-routine and stage the two workflows so that I get Results message for each routine?  The reason I'm thinking of this approach is that in this sceanario, and many others, you do not get verification that your formula resolved all the warnings especially if the problem occurs in multiple columns and because the warning is only reported during the input process. 

A similar problem occurs with rows of all Null values. The warning tells me that there are not enough fields in the record.  I know why it occurs and I deal with it in the workflow but I would like to deal with the error during the input process and know it is resolved before the data hits the main part of the workflow.  Thanks.

jack_morgan

Putting in a filter that will remove data all together if it isn't to spec would work instead. Get creative and use something like with (startswith([field_name],'"') OR right([field_name],2)='""'

Those in combination would give you any value that starts with a double quote or ends with 2 double quotes, that last piece should address for your column that has the legitimate double quote in it. Don't limit yourself to only checking the data on the input, other tools can address this issue for you along the way.

Jack