Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

Need help with a formula to check source fields for data


Joe Woltering

Recommended Posts

I need to write a formula in Scribe Insight Workbench that checks two fields for data with 3 possible outcomes. For some reason, it's just not coming to me.

e.g.

Field 1 CONTAINS DATA but Field 2 DOES NOT CONTAIN DATA = Outcome #1

Field 1 DOES NOT CONTAIN DATA but Field 2 CONTAINS DATA = Outcome #2

Neither Field 1 NOR Field 2 CONTAIN DATA = Outcome #3

 

I've tried nested IF statements using ISEMPTY but I am only able to ever produce two outcomes.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...