Comparing Two Consecutive Subobjects
I’m trying to move job history records from one system into another using SnapLogic, and the actual data transformation is working great. However, a requirement has come up that I need to check that,...
Forum Discussion
Try this pipeline:
Community7373_2020_04_29 (1).slp (6.2 KB)
The crux is a Mapper with an expression like this:
match $.Employee.findIndex(e => e.Action == "Termination") {
i if i == -1 => "VALID",
i if i == $.Employee.length - 1 => "VALID",
i if $.Employee[i+1].Action == "Rehire" => "VALID",
_ => "INVALID"
}
