Hi, for our night shelter we are looking for a system that searches for double entries and also their exit reasons based on the date of exit. So the source has some recurring clients, an exit date and an exit reason.
The destination has a list of all recurring clients (double or more). Next to each client we would like to see the EXIT REASON based on the month and year. With this we can find out how their journey was within our system.
I thought it was possible to use Xlookup but can't work it out properly. Hope some one has the answer. Kind regards, Art
The destination has a list of all recurring clients (double or more). Next to each client we would like to see the EXIT REASON based on the month and year. With this we can find out how their journey was within our system.
I thought it was possible to use Xlookup but can't work it out properly. Hope some one has the answer. Kind regards, Art