how to get the status on the like vlookup

[Amy123]

Hi Team,

Can anyone help me to get the output on find sheet- Status column. Please consider Concatenate Order segment to perform vlookup with replace sheet

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

[JoaoLeiteV]

Hello there @Amy123,

It seems you have other 2 posts with the same question haha. If possible, try removing them so we'll have your answers in only one post.

"VLOOKUPS" can usually be done via a Join Tool inside Alteryx Designer, but looking at the table you've shown, I don't know exactly what you're trying to achieve.

If we use the lower part, marked as "Find", we could try getting the Status. But as all keys are the same, it wouldn't make sense. Could you provide an example with different keys for input/output?