Conditional Split Expression

Question

Hi all

Select

 

LOBID, Region from TableA

where LOBID IN ('7', '1') AND

Region

= 'Leased MArkets'

how to write the above expression in the Conditional split Task.

Thank you

suman

Answer 1

I believe that you can use something like the following:

 

([lobid] == "7" || [lobid] == "1") && [region] == "Leased Markets"

---

Please mark answered posts. Thanks for your time.

Answer 2

I am trying to put the below condition in my conditional split, it throws me an error.. Could you plz rectify the error and help me with the right query

(LOBID == "14" || LOBID == "15")  &&  FINDSTRING( [Line Of Business] ,"[2",1 )

Answer 3

I got the solution

Answer 4

Others that look at your threads later would appreciate it if you:

a) Mark the post that answered your question (or took you most of the way there).

b) Stated the actual solution (if none of the posts stated it exactly).

For example, you should say you used this expression:

(LOBID == "14" || LOBID == "15")  &&  (FINDSTRING( [Line Of Business] ,"[2",1 ) >= 1)

---

Talk to me now on