DSXchange

Hi,

I need to write Dynamic Data Quality Rule In IA like below ~

If Country = 'Finland' Then VAT should have 10 characters with first 2 character as 'FI' and last 8 as digit (i.e. FI12345678)
If Country = 'Belgium' Then VAT should have 12 characters with first 2 characters as 'BE' and last 10 as digit with leading 0 (e.g. BE0123456789)
.......
......
In this way I have to check for 10 Countries.

My question: Is there any way to write IA Code dynamically like, if I want to run only for Finland at run time we can provide country name as Finland and Quality Rule (If Then) for Finland will run.

Please suggest.

Not within the rule itself. But you could apply a Filter to the data being profiled.

You could create a virtual table for each country, and then run the country rule against the country virtual table.