Want to create new field with data of 3 existing fields

[#1]

Hello Friends,

I have 3 different fields count1,count2 and count3. Now, i want all these 3 fields under one field  "Count"

I have the following fields

Count1     Count2       Count3

-----------   -------------   -----------------

125            231            98

Now i want

Count-Name   Count

---------------------------------

  Count1           125

  Count2           231

  Count3            98

Any help is greatly appreciated.

[#2]

I am sorry Jens Frederik,

I am getting the error as   "Field not found - <Count1>"

Thanks a lot

[#3]

Vishwaranjan, Sorry to say that i am not using any flat files, i am just connecting to DB and by query i am fetching the fields.

Thanks a lot for your reply.

[jfkinspari]

Okay, I see that count1 in the SQL statement and Count1 in the LOAD statement uses an upper and lower 'c'. That's causing the error.

[#5]

But i have given same case in SQL statement and LOAD statement as well.