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 |
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?