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"
}
Hello suresh_fm,
Please find the attached pipeline with the sample file that I've used to achieve the wanted parsing of the txt file.
Let me know if this helps you.
Regards,
Aleksandar.
