Grouping values

[GaneshLakshman]

Hi,

I have a column called points in which there are values from 1 through 10.

I have to group them like 1-5 as class A, 5-7 as class B, remaining as class C in another column called classlevel.

Is there a way to do it? Tried class function but didn't help.

Thanks

Ganesh 

[dplr-rn · Accepted solution]

Why not if statements?
If(yourfield<=5,'Class A',if(yourfield<=7,'Class B', 'Class C') ) as ClassLevel

or is your logic more complicated than specified?

[GaneshLakshman · Accepted solution]

This works.. But the table has close to 60 million records, Is there any way we can use if statements and still preserve optimised load? 

[dplr-rn · Accepted solution]

Unfortunatly cant think of any unless you can do the transformation in a resident load after loading the qvd.

[Channa]

Grouping can use IntervalMactch for large data