Garbage after statement

[#1]

Hello,

Can anyone tell me why I am getting a Garbage after statement on the following lines in the load script?

QUALIFY *;

NSOProvider:

LOAD BreakoutProviderSideActivity.ID,

    BreakoutProviderSideActivity.Week,

    BreakoutProviderSideActivity.Employee,

    BreakoutProviderSideActivity.Team,

    if([BreakoutProviderSideActivity.Team]='CVN','NSO')  or

     if([BreakoutProviderSideActivity.Team]='OS','NSO') as BreakoutProviderTeam,

    [BreakoutProviderSideActivity.Days Booked]

RESIDENT

    BreakoutProviderSideActivity

    Where [BreakoutProviderSideActivity.Team] in('CVN','OS','NSO');   

UNQUALIFY *;

[#2]

It seams to me that you use the IN where clause like in SQL. In qlikview you can use the match syntax. So in your case replace:

Where [BreakoutProviderSideActivity.Team] in('CVN','OS','NSO'); 

by

Where match([BreakoutProviderSideActivity.Team], 'CVN','OS','NSO');

you can also change your if by:

'NSO' as BreakoutProviderTeam

because you are alseady filtering 'OS' and 'CVN' in your where condition

[#3]

On the NSO I want that data, but where the team is CVN or OS I am changing the team to equal NSO. Will the way I am doing this actually work? I want to roll everything on CVN and OS teams up to NSO.

Thank you so much in advance.