Can i validate the correctness of a code?

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
Hi,
   during profiling using regular expression i can match for example vat number pattern inside column data. Can i also validate the correctness of that code by verifying that the last two digits are correctly derived from the previous one by applying an arithmetic formula?
Best Regards,
Luigi
Photo of luigidep

luigidep

  • 622 Points 500 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Anders Karlsson

Anders Karlsson

  • 110 Points 100 badge 2x thumb
Official Response
Hi Luigi,

Thanks for your question. 

The Masking Engine uses regular expressions (RegEx) to find matching patterns in the data. This applies to both the column name (Column Level) and at the data in the column (Data Level). RegEx uses fixed expression and as such can't cater fro dynamic expressions - i.e. including a calculation of formula (arithmetic or string). To do this kind of validations you may need to use a SQL statement or another tool.

I hope this answer the question.

Kind regards,