Kettle 6.1 Data Flow selection with JS script and Switchcase

Scene:

Determine if the extracted data already exists in the target library (if the same patient already has a treatment plan number):
1. If it does not exist, then grouprowno=1 and insert into Target library (judging if the outer associated field is empty)
2. If existing (the same patient already exists the treatment plan number), then determine whether the update time is the same
2.1 If the extracted data creation time, modification time and target library creation time, modified time is the same, the data is identical
The update operation is performed or no action is taken
2.2 If the extraction data creation time, the modification time and the target library creation time, the modification time is different, the description is the same scenario number version of the data
Grouprowno+1 the target, set the Originaltreatmentplanno to Treatmentplan_no_ods, and insert the into target library

Kettle 6.1 Data Flow selection with JS script and Switchcase