help with field value grouping

[hopkinsc]

Hi,

I have a field in my table that i want to make a grouping of...

Table 1:

Field A,

Field B,

Field C,

Field D,

Name,

RG

From.....

the Name field has a list of names, and the RG field is a flag of Y.. eg..

Name                         RG

Name A                         Y   

Name B

Name C                         Y

Name D

Name E                         Y

Name F                         Y

Name G

Name H

I want to group the names with an RG flag against them and rename them something else (NAME RG)

So i want to end up with a Name field that will show all of the names, plus the new value of NAME RG. i can then select either the individual names or the NAME RG which will make a selection on all of the RG Names.

Does that make sense?

[vgutkovsky]

Not quite sure why you'd want to do this (seems like you can probably accomplish what you need by referencing the RG flag from set analysis in the front end) but the syntax is: if(RG='Y',Name) as [Name RG]

Regards,

Vlad

[hopkinsc]

Hi, i dont want this in a chart. i want a list box to show all names PLUS a new value for the grouping.

I can then select the new grouping value from the list box and see all data relating to the RG names.

my new field will look something like ..

Name A                          

Name B

Name C                        

Name D

Name E                        

Name F                        

Name G

Name H

NAME RG

thanks

[vgutkovsky]

Still seems to me like the easiest way to do this would just be to create a list box of flag RG. However, if you have your heart set on this solution, you'd need to create a separate table which will take you to a different granularity:

//First, load all names

Names:

LOAD

      Name, //key to your existing table

      Name as [Names (new)] //new field that will be displayed as a listbox

RESIDENT Table1;

//Then, add on values for RG names

CONCATENATE (Names) LOAD

      Name, //key to your existing table

      'Name RG' as [Names (new)] //new field that will be displayed as a listbox

RESIDENT Table1

WHERE RG='Y'

;

Regards,

Vlad