on 12-31-2014 12:39 PM
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!!
Try this:
CASE WHEN A.criteria = 'Sauce' THEN
CASE WHEN B.Criteria = 'Gel' THEN 'X'
ELSE 'Y'
END
ELSE 'Y'
END
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.