Fetch derivation rules from a lookup table

[garthmac]

We have a job that runs for multiple countries, each having different transformation rules depending on the country that is being processed. Some derivations are becoming overly complex and difficult to maintain (if then else statements etc).

We have tried creating a lookup table that contains these derivations for each country, but these appear as strings instead of derivations in the transformer. Is there any way around this - perhaps a routine that converts this string to a derivation in the transformer? Does anyone have any other suggestions on how we could handle this?

Any help is greatly appreciated.

Thanks

Garth

[ray.wurlod]

You might try looking at this thread

[garthmac]

Thanks for your quick reply Ray. I'll investigate what you suggest in that thread.

Garth