-
Group in Validate step
Is it possible to Group in Validate Step. My Goal is to get the Data Along with the Stat example I want to see how many contacts are active , inactive and Passive along with that when I click Active stats it shows me the data like the way we can do in interactive snapshot.
-
Has anyone noticed varying results checking domain validity of same email list a day or 2 later?
-
How to optimise Validation, Filter, and Take Snapshot Steps
Hey folks, Can anyone help me with optimising performance on Validation, Filter, and Take Snapshot Steps, and hopefully also provide some benchmarks for expected performance? We have several datasets that we are cleansing, and then separating into passing and failing records based on them containing enough valid data…
-
Get the 6 month Older Date from Today
Is there any easy way to get the date which is 6 months older than today?
-
2 questions on TRANSFORM
Looking for ideas from community. 1) Transform – ‘Equals’ Command I am in a workflow to check if the input file matches to data loaded in SAP Table. There are about 70 columns and I want to create new 70 check columns as follows: field1_input equals field1_Sap field2_input equals field2_Sap ... …. field70_input equals…
-
Filtering within a validation rule
Hi, I have the following scenario for a validation rule and I'm struggling with the logic. Column A has X, Y, Z as values and column C has 1,2, 3 as values. So, my validation rule is "IS NULL" against column A, however I want it to return only when column C is equal to "2". Also, I need to build the above rule within a…
-
Suggest Validation rules - Validate step
Aperture Data Studio has a Validate workflow step that allows you to define rules of how data in specific columns should be populated. This information can then be used to be alerted to any data quality problems or to track data quality improvements over time. These rules can be simple: should not be null should be a…
-
How to validate US dates stored as YYYY-MM-DD
I have several fields that have dates stored in the format above. If I run the built in function "Is Date", the dates all fail. Is there a date system setting I need to change, or create my own function? What date format does the "Is Date" function require?
-
Force workflow failure due to failing rows
Is there a way I can force a whole workflow to fail as a result of failing rows in a validation step(at desired tolerance level)? I want my workflow to stop and fail when I have a certain number of failing rows. I have email notifications set up with fire event to email me when I have failing rows but I also want the full…
