Grouping in List Box

[mhmmd_srf]

Hi All,

I have a field called GroupMajorCode. Which is having values 1 to 100.

My requirement is to create a List Box. List box should show three values:

1.Core Group Major

2.Bluepoints Group Major

3. Consolidated

when GroupMajorCode <> '071', Core Group Major

when GroupMajorCode = '071', Bluepoints Group Major

when GroupMajorCode is all including '071', Consolidated.

I am using below script  in my load script:

if(GroupMajorCode <> '071', 'Core Group Majors',

if(GroupMajorCode = '071', 'Bluepoints Group Majors',

if(GroupMajorCode <> '0','Consolitated'))) as GroupMajor,

but I am only getting first two, not getting consolidated.

Can anyone please help me to do the same.

Thanks for your help.

Sarif

[tresesco]

I guess you have to use two loads like:

Load

if(GroupMajorCode <> '071', 'Core Group Majors',

if(GroupMajorCode = '071', 'Bluepoints Group Majors')) as GroupMajor

From <>;

Concatenate         //This might not be needed if autoconcatenated

Load

if(GroupMajorCode <> '0','Consolitated') as GroupMajor

From <>;

[sunny_talwar]

I don't think this is possible directly in the list box object.... the only option I see is to do it in the script like tresesco‌ mentioned or do this in a Link Table to minimize any effect in your fact table (in case it is huge).... process of how to do it will stay the same in any case (as shown by Tresesco above)