IF Condition with AND and OR

[venkat352]

Hi,

How can I implement the AND or OR within my transformation? Below is the code I am trying to achieve.

"#ifgroup(#ifcondition(#currentvalueatpath($.Type),Sales,True,False)) #or #ifgroup(#ifcondition(#currentvalueatpath($.Type),Purchase,True,False))": {
"Property": [
{
--Transformation code
}
]

"#ifgroup(#ifcondition(#currentvalueatpath($.Type),Sales,True,False)) #and #ifgroup(#ifcondition(#currentvalueatpath($.Type),Purchase,True,False))": {
"Property": [
{
--Transformation code
}
]

[Courela]

As I understand you want to include or not some object, thus the use of #ifgroup, correct?
For simulating AND/OR operators, you could use nested #ifcondition.
For OR:

...
"#ifgroup(#ifcondition(#currentvalueatpath($.Type),Sales,True,#ifcondition(#currentvalueatpath($.Type),Purchase,True,False))": {
  "Property": [{
    --Transformation code
  }]

For AND

...
"#ifgroup(#ifcondition(#currentvalueatpath($.Type),Sales,#ifcondition(#currentvalueatpath($.Type),Purchase,True,False),False)": {
  "Property": [{
    --Transformation code
  }]