IF Function

Support for DataSlave

Moderators: Tom, ian

IF Function

Postby MrsRodriquez » Wed May 02, 2012 5:00 pm

Is there any way to use mutliple IFs in the IF function, for example like

If input1 is less than 100 then 'Less than 100'
else if input1 is more than 100 and less than 200 then 'between 100 - 200'
else if input1 is more than 200 and less than 300 then 'between 200 - 300'

It is possible?
MrsRodriquez
 
Posts: 2
Joined: Wed May 02, 2012 4:49 pm

Re: IF Function

Postby ian » Fri May 04, 2012 7:47 am

Could you send more details of what you want to achieve. Are you changing data in a column based on a value in that column or another column?

Here are some initial thoughts:

  • There is no Case function, but you can string IF statements together to effectively nest them.
  • If the number of possible values is reasonable small you can use the Lookup function against a file with values and resulting values.
  • You could also use a script object.

If you could send a more details indication of the requirement with some samples of data we will build a sample map tom illustrate how to address this requirement.
ian
 
Posts: 364
Joined: Sat Dec 18, 2004 8:13 am
Location: UK


Return to Support

Who is online

Users browsing this forum: No registered users and 1 guest

cron