Skip to Content
avatar image
Former Member

In IDT, Need to create one formula using condition

Hi Experts,

Can you please help me creating one formula in IDT. I have two tables A and B and 'Criteria' is a column in both tables having the same data values such as Sauce, Gem, Gel etc.

Now, I have to give the following condition in IDT

If (A.Criteria = 'Sauce' and B.Criteria = 'Sauce') then 'X' else 'Y'

Which function I have to use in IDT for this condition? I have used 'IfElse' function but it is not taking the two conditions inside the function. I used 'Case' also but no luck.

Please help me with formula which should work properly in IDT.

Thanks in advance.

Wish you all a Very Happy New Year!!


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 02, 2015 at 03:22 PM

    Try this:

    CASE WHEN A.criteria = 'Sauce' THEN

         CASE WHEN B.Criteria = 'Gel' THEN 'X'

              ELSE 'Y'

         END

         ELSE 'Y'

    END

    Add comment
    10|10000 characters needed characters exceeded