Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
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