topic Re: Conditional check in GeoAnalytics

Conditional check

Tue, 25 Apr 2017 09:03:03 GMT

In my code i am trying to give weightage as 100 if the 3 conditions are true ,75 if only 2 conditons are true, 50 if only primary skills is true.

help me to do this..

if [Primary Skills]=='java' then

weightage= '50'

elseif [ Primary Skills]=='java' and subskills_1=='Java Enterprise - Front End' then

weightage='75'

ELSEIF [ Primary Skills]=='java' and subskills_1=='Java Enterprise - Front End' and subskills_2=='Java Enterprise - Back End' then

weightage='100'

end if

Re: Conditional check

sunny_talwar — Tue, 25 Apr 2017 11:31:31 GMT

Where are you trying to do this? Front end or back end?

Re: Conditional check

Tue, 25 Apr 2017 11:40:12 GMT

In script

Re: Conditional check

Tue, 25 Apr 2017 11:42:18 GMT

In script

Re: Conditional check

sunny_talwar — Tue, 25 Apr 2017 12:26:53 GMT

Should be like this

LOAD [ Primary Skills],

subskills_1,

subskills_2,

If([ Primary Skills] = 'java',

If(subskills_1 = 'Java Enterprise - Front End',

If(subskills_2 = 'Java Enterprise - Back End', 100, 75), 50)) as weightage

FROM ....

UPDATE: Missed a closing parenthesis... added now

Re: Conditional check

beunderf — Tue, 25 Apr 2017 12:32:07 GMT

It would be somthing like this in your load script:

IF([ Primary Skills]=='java' and subskills_1=='Java Enterprise - Front End' and subskills_2=='Java Enterprise - Back End' ,100

,IF([ Primary Skills]=='java' and subskills_1=='Java Enterprise - Front End'

,75

IF(if [Primary Skills]=='java'

,50)))

AS weightage

Re: Conditional check

manoranjan_d — Tue, 25 Apr 2017 12:32:39 GMT

suppose if we are trying to do in front end how we will do?

Re: Conditional check

sunny_talwar — Tue, 25 Apr 2017 12:33:15 GMT

This should do it

If([ Primary Skills] = 'java',

If(subskills_1 = 'Java Enterprise - Front End',

If(subskills_2 = 'Java Enterprise - Back End', 100, 75), 50))

Re: Conditional check

Wed, 26 Apr 2017 03:25:58 GMT

thank you.. that would be helpful

Re: Conditional check

Wed, 26 Apr 2017 03:26:15 GMT

oh thank you..

Re: Conditional check

Wed, 26 Apr 2017 03:49:43 GMT

Re: Conditional check

Wed, 26 Apr 2017 03:53:34 GMT

Its not displaying the weightage value..wat to do