Skip to main content Skip to complementary content
Qlik Resources
Loading SearchUnify's search If you need assistance with your product, please contact Qlik Support.
Qlik Customer Portal
Loading SearchUnify's search If you need assistance with your product, please contact Qlik Support.
Qlik Customer Portal

Setting patterns

You would want now to match the content of the email column against a standard email format and the postal column against a standard US zip code format.

This will define the content, structure and quality of emails and zip codes and give a percentage of the data that match the standard formats and the data that does not match.

Procedure

  1. In the Analyzed Columns view, click the icon next to email to open the Pattern Selector dialog box.
  2. Expand Regex > internet, select the Email Address check box and click OK to close the dialog box.
  3. Click the icon next to the Email Address indicator and set 98.0 in the Lower threshold (%) field.

    If the number of the records that match the patterns is fewer than 98%, it will be written in red in the analysis results.

  4. Do the same to add to the postal column the US Zipcode Validation pattern from the address folder.

    For further information on pattern types and their usage when analyzing data, see Talend Studio User Guide at https://help.talend.com.

    For further information on pattern types and their usage when analyzing data, see Talend Studio User Guide.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here