@deepsingh,
Observations:
It looks like you are going to return the values of 0 & 1. I would use a numeric data type of "Boolean" for these values. If you want a string "0" and "1", then I would use STRING with a length of 1.
The IF statement has 2 conditions being tested. When either condition is True, or more specifically in any case where the first condition is true plus those conditions where the first condition is false and the second condition is true, then the result is 1. The default value of 0 is set when the condition tests are not true.
Recommendation:
Summarize your data (Group by Order_id, ull, Action Name & count of Order_id) and view the results to see if you should get any 0 results. The logic itself looks reasonable. Here is another construction of the logic:
IF Contains([Action Name], "HMS_bModify_ORDER") THEN 0
ELSEIF !sNull([Order_id]) && !IsNull([ull]) THEN 1
ELSE 0
ENDIF
I chose to write the statement this way to illustrate that whenever the Action Name includes the "HMS_bModify_Order" text, that you want the value to be 0. The ELSEIF looks to see if the other variables have ANY value (including space or '') that the result is 1. The else condition would only occur with a NULL value to either Order_id or to ull. It doesn't matter what value ull has.
Another statement would be:
IF !IsNull([Order_id]) and !IsNull([ull]) and Contains([Action Name],"HMS_bModify_Order") THEN 1
ELSE 0
ENDIF
Cheers,
Mark
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please
Subscribe to my youTube channel.
