add a calculated column

[#1]

I need to add a calculated column, the table original is like bellow

NAME	POINT
AAA	1
BBB	2
CCC	3
DDD	4
EEE	5
FFF	6
GGG	7

i want to add a columne LEVEL, is value of point between 1 to 3, it's LOW, between 4 to 5, it's MEDIUM,else, HIGH

The final table is like this ? How to proceed???

NAME	POINT	LEVEL
AAA	1	LOW
BBB	2	LOW
CCC	3	LOW
DDD	4	MEDIUM
EEE	5	MEDIUM
FFF	6	HIGH
GGG	7	HIGH

[tresesco]

If(POINT<4, 'LOW', If(POINT<6, 'MEDIUM' , 'HIGH')) as LEVEL

[alexandros17]

LOAD

     NAME,

     POINT,

     If(POINT>=1 and  POINT<=3, 'LOW', If(POINT>=4 and  POINT<=5, 'MEDIUM', 'HIGH')) as LEVEL

...

Let me know

[mdmukramali]

Dear,

kindly find the attached file..

i hope it will help you.

thanks,

Mukram