https://communities.sas.com/t5/SAS-Data-Management/Data-validation-transformation/m-p/467354#M14609 <P>Difference between Error table and Exception table of Data_Validation_Transformation?&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;version 4.2 di studio...</P><P>can you give example?</P> Mon, 04 Jun 2018 11:59:18 GMT katkarparam 2018-06-04T11:59:18Z https://communities.sas.com/t5/SAS-Data-Management/Data-validation-transformation/m-p/467354#M14609 <P>Difference between Error table and Exception table of Data_Validation_Transformation?&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;version 4.2 di studio...</P><P>can you give example?</P> Mon, 04 Jun 2018 11:59:18 GMT https://communities.sas.com/t5/SAS-Data-Management/Data-validation-transformation/m-p/467354#M14609 katkarparam 2018-06-04T11:59:18Z https://communities.sas.com/t5/SAS-Data-Management/Data-validation-transformation/m-p/467413#M14611 This transformation have been given a face lift in later releases, so I urge you to upgrade (either way)!<BR />If you look in the generated code you'll see the the table layouts, and even see the logic if you look to dig.<BR />The documentation here is quite scarce, but on short the error table contains the records that doesn't copy with the validation criteria (optional by defonition) and validation table tells you what actually went wrong. Its not uncommon you wish to joins those to get the full picture. Again, simpler and better in later releases. Mon, 04 Jun 2018 14:21:24 GMT https://communities.sas.com/t5/SAS-Data-Management/Data-validation-transformation/m-p/467413#M14611 LinusH 2018-06-04T14:21:24Z