
Not applicable
2012-01-25
04:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
grouping values
Hi I got a field (A) with values going from 1 to 9 (maybe with new data will go over 10) and i need to group them into 3 categories of a new field (B):
If A=1 then B='1'
If A=2 then B='2'
If A>=3 then B='3+'
could you help me in writing the right script to build up the new field?
Thanks in advance
786 Views
2 Replies

Champion II
2012-01-25
04:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
use below code
If (A=1, B='1',
If (A=2 , B='2',
If (A>=3 , B='3+')))
hope this helps
Sunil Chauhan
358 Views


Partner - Champion
2012-01-25
05:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Load
A,
If(A=1,'1',If(A=2,'2',if(A>=3,'3+'))) AS B
From
Table;
May be your need is this..
Celambarasan
