Forum Discussion
Counting matching information inside the same table with multiple lines under each date
ePros ,
Here is one approach that uses Power Query.
1. Add a Custom Column and name it something like "Concat":
if [Outbound] = "" then [Date] & [Inbound] else [Date] & [Outbound]This will give you a column in which you will have your Duplicate values. Unable to describe the next steps in detail, but a google search for "Power Query find Duplicates" will give you the detailed steps you can follow to identify those records that have your Duplicate values.
Hope you can take it from this point on.
Regards,
Community ChampionePros ,
Here is one approach that uses Power Query.
1. Add a Custom Column and name it something like "Concat":
if [Outbound] = ""
then [Date] & [Inbound]
else [Date] & [Outbound]
This will give you a column in which you will have your Duplicate values. Unable to describe the next steps in detail, but a google search for "Power Query find Duplicates" will give you the detailed steps you can follow to identify those records that have your Duplicate values.
Hope you can take it from this point on.
Regards,
I like the thought process and I am sure it is the start, but actually if I made multiple outbound calls to the same number that day, it would show up like a match. But I will dig deep as my outbound and inbound are already added columns based on call type and disposition and I might be able to concat there and then match.
Thank you
Thank you, keep in mind sample data was just for concept, real data much more complicated, but ultimately concating date and phone is what worked, had to add extra column for date and outbound and column for date and inbound then Lookup value column to search concated out against concated inbound to avoid muliple calls outbound, then use distinct count of lookup column. I appreciate your insight.
