Dear Sir / Madam,
So I have two excel tables. Mother name.xlsx is the original data and waterbody.xlsx is another table.
So I would like to compare two excels. If both excels' column "ModelName" are matched. The mother name excel's model name column should change to newmodelname column. If not, just keep the original modelname.
I try to use tester transformer but I am not sure why nothing can be matched.
I hope someone can give me a hand.
The output that I want is in the Output.xlsx
Thank you very much.
