topic Re: Grouping values in App Development

Grouping values

GaneshLakshman — Wed, 12 Jun 2019 16:19:01 GMT

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

Re: Grouping values

dplr-rn — Wed, 12 Jun 2019 16:25:25 GMT

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?

Re: Grouping values

GaneshLakshman — Wed, 12 Jun 2019 16:33:22 GMT

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?

Re: Grouping values

dplr-rn — Wed, 12 Jun 2019 16:36:20 GMT

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

Re: Grouping values

Channa — Thu, 13 Jun 2019 01:24:52 GMT

Grouping can use IntervalMactch for large data