IA: Dynamic Data Quality Rule In Information Analyzer

[pranabdas]

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.

[ray.wurlod]

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

[rjdickson]

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