Create a Global Transformation Rule for Adding Columns for new Keys
We have a large number of data sets from a single source that requires us to set up and create new 'key' fields. Right now, we create multiple transformation tasks to do this key setup on every data set, but it's always the same transformation tasks each time.
For example, I have FieldA and FieldB. The fields, between all tables, will be named the same thing. For one of the keys, I need to create a KeyField made from FieldA and FieldB. So, for one record, if FieldA = Blah and FieldB = 1234, then KeyField = Blah1234.
Again, I can do this in transformation tasks, but I have so many tables to do this to, it would be very helpful to find a way to use transformation rules instead.
