Skip to Content
Author's profile photo Johnpaul Joseph

Pattern Check using SAP Information Steward

Pattern Check using SAP Information Steward

SAP Information Steward is a very good tool for all the Data Quality profiling activities. Using the Profile Attribute setting “Distribution”, we can measure and validate the Pattern & Word Distribution on the Particular column. For example in the Email Address Column we can do a quick sampling on the whole lot of records and analyse how many records coming in each pattern.


Step 1: Select a Table and apply ‘Column Profiling’ as shown below.


Step 2: Select Median & Word Distribution options


Step 3: Save & Run the Task

All the patterns are captured by Info Steward


Step 4: Lets select the Email Address Pattern. It will lists all the 6 pattern in the right pane.


Step 5: If you select the pattern, it will show the corresponding Record of the particular pattern.


This will reduce lot of sampling &manual efforts of analyzing the data.


John Paul Joseph

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Niels Weigel
      Niels Weigel

      Great quick post on Pattern Analysis within Information Steward. You might find more information on Information Steward on our specific SCN side for Information Steward:


      Author's profile photo Johnpaul Joseph
      Johnpaul Joseph
      Blog Post Author

      Thanks Niels, Moving onwards i will share more thoughts about Info Steward.