make group for records

[Anonymous]

if I have TABLE01 contain (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19) and i want to make table02 contain (A,B,C,D). so when I select A in table02 it should show me (1,2,3,4,5) in table01, and when I select B in table02 it should show me (6,7,8,9,10)..

if the example is not clearly, i will put live example.qvs

[sunny_talwar · Accepted solution]

Is TABLE01 a column here???

May be this;

LOAD TABLE01,

          If(TABLE01 < 6, 'A',

          If(TABLE01 < 11, 'B',

          If(TABLE01 < 16, 'C', 'D'))) as TABLE02

FROM Source

[Kushal_Chawda]

It's confusing. TABLE01 is the field or table?

[Anonymous]

i have this table SEGMENT2 and i want to make group for this numbers so each number start with 10 = salaries, 11 = depreciation.. so when i select salaries i want to show breakdown list with all number start with 10

[Mark_Little]

Hi,

     If(LEFT(SEGMENT2,2) = 10,  'salaries',    

          If(LEFT(SEGMENT2,2) = 11, 'depreciation')

          ...                                                       // Other groupings

        )  AS Grouping

Should give you this grouping,

Mark

[sunny_talwar]

Or this:

Pick(WildMatch(SEGMENT2, '10*', '11*', and so on), 'Salaries', 'Depreciation') as Group