Using fields and variables to rename fields during load

[#1]

HI

OK, I have a table with columns Ref, M_0, M_1, M_2, M_3, M_Offset and Year

I want to load the rows of the table with field names that are calculated from the M_offset value

i.e. if in the first row, M_Offset = 3, and Year = 2009 then I want to rename M_0 as March_2009, M_1 as April_2009, etc

The next row may have a different offset i.e. 11, in which case M_0 would become November_2009, M_1 = December_2009 and M_2 = January 2010

and so on

Has anyone any ideas?

I have tried using Load M_0 as if(M_offset = 3,March & Year,.........

Thanks in advance

[rwunderlich]

khetienne wrote:
Yup! Works! - does exactly what I wanted
 <div></div>

Which suggestion worked?

-Rob