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