IF/LIKE operator question

Tue, 12 Nov 2013 17:19:36 GMT

I need help with coming up with the correct syntax in my load script that I believe requires the IF operator.

I have a field (JOB_GROUP) where the values consist of backup jobs and application jobs. All of the field values that start with BU are backup jobs and everything else are application jobs.

In my load script I think the best approach would be to create two addition fields (BACKUP_JOB and APPLICATION_JOB). I intend to add a list box to my document so that users can filter on the job types.

I’m not sure if I should be using the LIKE or MATCH operator or something else entirely when creating these new fields. Any help would be greatly appreciated.

Re: IF/LIKE operator question

Anonymous — Tue, 12 Nov 2013 17:26:15 GMT

Shannon

In your load script how about:

if ( left( [JOB_GROUP] , 2 ) = 'BU' , 'Backup Job' , 'Application Job' ) as [Job Type]

Best Regards, Bill

Re: IF/LIKE operator question

Tue, 12 Nov 2013 17:32:06 GMT

This works and got me what I needed. Thanks so much!

topic IF/LIKE operator question in QlikView

IF/LIKE operator question

Re: IF/LIKE operator question

Re: IF/LIKE operator question