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