Skip to main content
To homepage To homepage

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? 

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


Terms and ConditionsCookie settings