Using components: Assert

Use the Assert component to make sure that all data in the source complies with the conditions you specify in the component. If a record does not comply, the job fails and a message is added to the error log.

To set the assert conditions:
  1. Add an Assert component where required in your package.
  2. Open the component and name it.
  3. Under settings, in the assertion message text box, type the alert message that will appear if a record is blocked by the conditions (that you will specify below) as follows:
  4. Under conditions, indicate how the filter should apply the conditions (that you will specify below) as follows:
    • all - selects records with values that meet all conditions specified (logical "AND")
    • any - selects records with values that meet any of the conditions specified (logical "OR")
    • none - selects records that don't meet all the conditions specified (logical "NOT AND")
  5. Specify a condition as follows:
    1. In the first drop-down list, select the field whose values you wish to filter. You can use functions in the field column to manipulate field data (see Using functions in components).
    2. In the second drop-down list, select the operator as follows:
      • For string fields, use operators that begin with "text". Use the "text matches" operator to look for patterns in a string field using regular expressions.
      • For numeric fields, use the mathematical operators.
      • You can also use is null or is not null.
    3. In the last text box, type the value that the condition will filter for.
  6. Add additional conditions as required.
  7. You can nest a condition by pressing Shift while hovering on the blue + icon that appears at the right of an existing condition until the icon changes to a blue right arrow.

Creating packages

  1. Creating a new package
  2. Create a package from a template
  3. Working in the package designer
  4. Using Components: Facebook Ads Insights Source (Beta)
  5. Using components: File Storage Source
  6. Using components: Database Source
  7. Using components: Google AdWords Source
  8. Using components: NetSuite Source
  9. Using Components: Google Analytics Source
  10. Using Components: Google BigQuery Source
  11. Using components: Google Cloud Spanner Source
  12. Using Components: Bing Ads Source
  13. Using components: MongoDB Source
  14. Using components: Amazon Redshift Source
  15. Using Components: Rest API Source
  16. Using Components: Salesforce Source
  17. Using components: Select
  18. Using components: Sort
  19. Using components: Rank
  20. Using components: Limit
  21. Using components: Sample
  22. Using components: Join
  23. Using components: Cross Join
  24. Using components: Clone
  25. Using components: Cube and Rollup
  26. Using components: Union
  27. Using components: Filter
  28. Using Components: Window
  29. Using components: Assert
  30. Using components: Aggregate
  31. Using components: Distinct
  32. Using components: File Storage Destination
  33. Using components: Amazon Redshift Destination
  34. Using Components: Salesforce Destination (Beta)
  35. Using components: Google BigQuery Destination
  36. Using components: Google Cloud Spanner Destination
  37. Using components: Database Destination
  38. Using components: MongoDB Destination
  39. Using and setting variables in your packages
  40. Validating a package
  41. Using pattern-matching in source component paths
  42. Using ISO 8601 string functions
  43. Using Expressions in Xplenty
  44. Xplenty Functions

Feedback and Knowledge Base