Hi Hai.kuo ok, here is what I would like to do I have an original table, containing the following columns: Population, Test1, Test2, Test3, etc. Columns 2, 3 and 4 are conbined in a group called "TARGETS". All Test... columns are numeric, continuous values. I would like to make a script which would do the following 1. Get a list of columns from a group "TARGETS" (will contain columns Test1, Test2, Test3) 2. Will create 3 new columns, calling each column New_Test1, New_Test2, New_Test3 3. Will assign a formula for each of the new columns, such as New_Test1 = Test1/10. hope this explains my case thanks
... View more