Jump to content
We have recently updated our Privacy Statement, available here ×

Joe Woltering

PowerCustomerSuccess
  • Posts

    4
  • Joined

  • Last visited

Everything posted by Joe Woltering

  1. 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.
  2. Seems like this should be fairly simple: I have an option set field with 3 values that I'm trying to update This is my formula where S1 and S2 are two source fields and 1, 2 & 3 are the possible target values. IF(S1 = 'Y', "1", IF(ISEMPTY(S2), "3", "2" ))
  3. Did you ever find a solution I am running into the same issue where the Wire Protocol driver only supports one "collection". I was forced to use the Wire Protocol driver some time ago as an update to Scribe broke my existing ODBC connection. Very frustrating.
×
×
  • Create New...