Forum Discussion
Solved
Return a value from one table based on two columns, one with a delimiter
Hello, I have two tables. One is a auto generated call data, the other is a list of outcomes for calls. I need to somehow create a column for the Auto generated Call data that compares both the Sta...
JBusque , Please try a new column in call table (First Table)
Maxx(filter(Outcome, Call[Start Time]<= Outcome[Time] && Call[End Time]<= Outcome[Time] && Search(Outcome[Name], call[Names],,0) >0) , Outcome[Outcome])
amitchandak
Super User
Super UserJBusque , Please try a new column in call table (First Table)
Maxx(filter(Outcome, Call[Start Time]<= Outcome[Time] && Call[End Time]<= Outcome[Time] && Search(Outcome[Name], call[Names],,0) >0) , Outcome[Outcome])
Yes this worked quite well, Thank you.