Resident table question

[#1]

I am using the Resident table to redifine certain teams Days Booked into other fields. I want my fields to pick up the label. For example I want CNVClient.BreakoutClientSideActivity.Days Booked. Below is the logic in the report script I am using. I can't get it to pick up the label. Any ideas?

BreakoutClientSideActivity:

LOAD BreakoutClientSideActivity.ID,

    BreakoutClientSideActivity.Week,

    BreakoutClientSideActivity.Employee,

    BreakoutClientSideActivity.Team,

    [BreakoutClientSideActivity.Days Booked]

FROM   

    [\\slcnasp01\Qlikview_Data\qliktech_user\DavidHill_Dev\2_Loaders-QVW\QVDs\BreakoutClientSideActivity.qvd]

(qvd);  

CVNClient:

LOAD BreakoutClientSideActivity.ID,

    BreakoutClientSideActivity.Week,

    BreakoutClientSideActivity.Employee,

    BreakoutClientSideActivity.Team,

    if([BreakoutClientSideActivity.Team]='CVN','NSO')  as Team ,

    [BreakoutClientSideActivity.Days Booked]

RESIDENT

    BreakoutClientSideActivity;

[#2 · Accepted solution]

Try the following, using the QUALIFY statement:

BreakoutClientSideActivity:

LOAD BreakoutClientSideActivity.ID,

    BreakoutClientSideActivity.Week,

    BreakoutClientSideActivity.Employee,

    BreakoutClientSideActivity.Team,

    [BreakoutClientSideActivity.Days Booked]

FROM  

    [\\slcnasp01\Qlikview_Data\qliktech_user\DavidHill_Dev\2_Loaders-QVW\QVDs\BreakoutClientSideActivity.qvd]

(qvd); 

QUALIFY *;

CVNClient:

LOAD BreakoutClientSideActivity.ID,

    BreakoutClientSideActivity.Week,

    BreakoutClientSideActivity.Employee,

    BreakoutClientSideActivity.Team,

    if([BreakoutClientSideActivity.Team]='CVN','NSO')  as Team ,

    [BreakoutClientSideActivity.Days Booked]

   RESIDENT

    BreakoutClientSideActivity;

UNQUALIFY *;