Load statements

Anonymous — Wed, 14 May 2014 10:27:20 GMT

I have a working load statement (Department), and want to add another from the same table so presumed id put it below - this hasnt worked though, what am i doing wrong? see below:

LOAD *,

If(Department =1, 'Blue Team',

If(Department =2, 'CNC Team',

If(Department =3, 'Green Team',

If(Department =4, 'Office Team',

If(Department =45, 'Admin Team',

If(Department =5, 'Red Team',

If(Department =6, 'White Team',

If(Department =7, 'Yellow Team',

If(Department =9, 'Aqua Team'))))))))) AS Team;

LOAD *,

If(WorkPattern =FC01, '39',

If(WorkPattern =FC02, '32',

If(WorkPattern =FC03, '39',

If(WorkPattern =FC04, '16',

If(WorkPattern =FC05, '19',

If(WorkPattern =FC06, '23',

If(WorkPattern =OF01, '39',

If(WorkPattern =OF02, '32',

If(WorkPattern =OF03, '24'))))))))) AS Hours;

Employees:

LOAD EmployeeNumber,

Department,

WorkPattern;

SQL SELECT EmployeeNumber,

Department,

WorkPattern

FROM EquatorCompanyA.dbo.TimBEEmployeeDetails;

Re: Load statements

hic — Wed, 14 May 2014 10:30:52 GMT

Your condition

WorkPattern =FC01

should probably be quoted:

WorkPattern ='FC01'

HIC

Re: Load statements

Anonymous — Wed, 14 May 2014 10:34:33 GMT

Thanks Hic, that worked! i dont understand why the first load didnt require quote marks then?

Re: Load statements

simondachstr — Wed, 14 May 2014 10:34:41 GMT

I recommend you to use ApplyMaps() instead.

Re: Load statements

simondachstr — Wed, 14 May 2014 10:35:01 GMT

Because it's numeric.

topic Re: Load statements in QlikView

Load statements

Re: Load statements

Re: Load statements

Re: Load statements

Re: Load statements