@Case combined with @if ?
I am trying to combine some conditions in OGG Transforms.
is it possible to combine goldengate transformation functions, for example embedding an @if inside a case statement? Or adding an extra condition for the case statement case 1 condition and extra condition, case 2 condition, case 3 condition. Example shows case 1 has additional condition once initial condition has been met.
I cannot find any examples where @case is used with @if or where AND criteria is combined in one case, but not with others. I have tried several combinations based on what I believe is correct syntax, but I get either colmap errors or transform errors, and the transform abends.