Find and replace not providing correct output

[Amy123]

Hi Team,

Can someone help me to bring the status on the find status column.

Replace	Segment	Order Number	Concatenate Order +Segment	Balance	Status
	1234		1234_	50000	Open
	1234		1234_	-232	Closed
Find	Segment	Order Number	Concatenate Order +Segment	Balance	Status
	1234		1234_	15000
	1234		1234_	15000
	1234		1234_	20000
	1234		1234_	-100
	1234		1234_	-100
	1234		1234_	-32

[dhavaldoshi]

Hi Amy,

What are you trying to use as the key, if it is Segment or Concatenate Order + Segment, it will not be able to decide whether it should show Open or Closed, and will show whichever is the first line i.e. Open in this case.

I would rather use a Join tool with multiple join parameters