Skip to main content
  • EN

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.

 

Before you can compare two values in one row, you must merge them. One way to do this is to use a FeatureMerger. Is this the pointer you needed?

Reply


Community Stats

30,364
Posts
115,373
Replies
38,148
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.