Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.