I have a multiple scenario to cover in a pipeline.
1)read an xml, validate the xml , send mail mentioning xml file name that it is not valid.
2)create lookup out of csv file which will have number, name, s1.
3)if xml is valid, check if <V_number> exists in lkp(number).
if yes, then transform the xml and name the output file with <V_number>_lkp(name)_timestamp.
4)if <V_number> does not exists in lkp(number) stop the execution and send mail mentioning xml file name.
I am able to transform the xml. My current pipeline looks like below:-