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