Creating a Default Rule for Blanks

Michael Lambert

• October 26, 2018 19:34
• Edited

When mapping with a default rule in dspMigrate, the action allows the user to assign a single value to all records containing that field. For example, a common default rule assigns the value of 'E' in the SPRAS (Language) Field in an SAP system, since other systems do not necessarily contain a separate language field.

But what if a user wants to assign a blank value (' ') to the field, perhaps to temporarily remediate null data or as a place holder, which would be converted to a manual rule for more complex operations? Thanks to the flexibility of the dspMigrate tool, this is easily achievable.

Map the field as a default rule and enter '<blank>' in the Default field in the Map section.

When generated by AutoGen, an update rule is created that inserts a single space into each record that contains the field for which the users intended for a blank.

Users can also enter in a single space (' ') when mapping this feature to achieve the same result.

BackOffice Associates offers professional, instructor-led training in an interactive hands-on style. To view the latest schedule of classes currently offered, visit https://www.syniti.com/support/education/

1

• 

  Victor Gazquez

  • November 05, 2018 10:02

  Thanks Michael,

  I would like to add that there are two additional options that we can use if we are using DSP 6.7.1 or higher.

  These are:

  <EMPTY> , in case you need '' instead of ' '. I find this particular useful as many times you need nothing instead of blank space.

  <NULL> , for NULL values.

  Regards

  1

Please sign in to leave a comment.