Section1 and Section2 flag

[manishapanda1]

Hi Friends ,

I have a scenario where i need to divide employees by their job level eg (employee whose designation is Managing director, executive director, vice president will comes under section1 and rest all will come under section 2 ) can some one please help to achieve this , i need to do this in script level .

Thanks,

Manisha P

[Yoshidaqlik]

Hi,

in this case would add more table to script load with your work level per employee

Example:

Table_1:
Load
employee,
etc,
etc,
etc,
From Table_1;

Support_Table:
Load
employee,
job_level
From Support_Table;

Hope this helps

Regards

[manishapanda1]

Thanks for the response,  i have all the data loaded , i have a field named Job title and under that field i have values  as( Managing director, executive director, vice president,associate,executive ,analyst) i just need a expression in the script like if(Job title= "Managing director, executive director, vice president" then senior  else junior)

[Yoshidaqlik]

this ?

if(WildMatch([Job title],'Managing director', 'executive director', 'vice president')>0, 'senior','junior')

you can use wildcards too

if(WildMatch([Job title],'*director*', '*president*')>0, 'senior','junior')

[manishapanda1]

I have already wrote this but i am getting only Junior not getting Senior as a result

if(Match(JobLevel,'[Managing Director]','[Executive Director]',
'[Vice President]')>0,'Senior ', 'Junior ' )as OfficerFlag

[Yoshidaqlik · Accepted solution]

try again without using '[]'

if(Match(JobLevel,'Managing Director','Executive Director',
'Vice President')>0,'Senior ', 'Junior ' )as OfficerFlag

[manishapanda1]

Thanks  lot it's working now 😊