_L and _M Behavior for Field Validations

  • 9 February 2022
  • 2 replies

Hi all,

I'll try to find out how to get rows in the _L table when I use a field validation. 

For field validation I can decide if I get a warning or an error information. But I only get a message in the _M like this:

How can I get the rows that don't match the field validation criterion to get an entry in the _L table? 


Best answer by JTreadwell 10 February 2022, 23:48

View original

2 replies

Userlevel 3
Badge +5

Hi Erich, 

Any rows in the Raw table that fall under the criteria of a validation rule will be listed in the _L table. 

The _L table consists of 2 columns:

  1. DW_Id of the matching row in the Raw table, and 
  2. Error number that corresponds to the error text in the _M table. 

Hi Joseph,
After I switched my insert table definition to RAW and improved my field validation, the errors also run into the _L table. Thank you Joseph!