Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
I've got a list box in which I have a lot of category's in the data so for example I have CHO names, I have 'Hospital Group' names and 'Others'.
At the moment Im just creating Inline map function and writing out the groups as shown below and that creates just a list box with below names.
//CHO Group
LOAD * INLINE [
CHO/HG Link, CHO Link
CHO 1 North West, CHO 1 North West
CHO 2 West, CHO 2 West
CHO 3 Mid West, CHO 3 Mid West
CHO 4 South,CHO 4 South
CHO 5 South East,CHO 5 South East
CHO 6 Dublin SE, CHO 6 Dublin SE
CHO 7 Dublin South, CHO 7 Dublin South
CHO 8 Midlands, CHO 8 Midlands
CHO 9 Dublin North,CHO 9 Dublin North
];
The problem is it is time consuming and I want to create another list box called 'Others' and just extract that data.
Is there away of picking my data from the large listbox and extracting this more quickly into aother smaller list box if that makes since!
Thanks a mill
Martin
Do you want to select a subset of the large list box? Have you looked at creating a bookmark?
Or you could enter text like this in the search box to select a bunch of values
('CHO 1 North West'|'CHO 2 West'|'CHO 3 Mid West'|'CHO 4 South')
Or do you want to make it easy for users to select a constant subset? Then use a flag field when loading the field in the large list box to identify the subset members.
May be something like this:
For example if you have all the value under "Field1", then:
A:
Load
if(Wildmatch(Field1,'CHO*'),Field1) as CHO/HG Link,
if(Wildmatch(Field1,'CHO*'),Field1) as CHO Link
resident Table;
B:
Load
if(Wildmatch(Field1,'Other*'),Field1) as Other/HG Link,
if(Wildmatch(Field1,'Other*'),Field1) as OtherLink
resident Table;
Hi Jonathan, basically I just want to create smaller listboxes with the category's in it, I've achieved this with the mapping inline but I'm typing out everything again from larger listbox.
Its just make it easier for the user to break it down into categorys.