Skip to main content
Solved

_L and _M Behavior for Field Validations


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

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. 
View original
Did this topic help you find an answer to your question?

2 replies

JTreadwell
Employee
Forum|alt.badge.img+5
  • Employee
  • 179 replies
  • Answer
  • February 10, 2022

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!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings