Forum Discussion
Outlook: how to link Inbox & Sent Items
Hi Dale,
attributes are the same, at least here we are at the same page:)
Please let me to explain step by step what is my way of working:
1. 2 tables imported from Exchange - Inbox and relevant Sent Items shared mailboxes.
2. Then I need to assign to each mail from Inbox related Sent date - what I mean by that is to get the date/time when particular mail was actually answered.
3. To make step 2 happen I need to find a 1:1 relation between those two tables:
4. According to your proposal I created a similar key in both tables:
5. I am afraid this combinations does not ensure us a unique key:
Am I doing sth incorrectly?
Regards,
Arek
Hi:)
can Dale or anyone advise with that issue?:)
Regards,
Arek
Hi Arek,
It's hard to create keys. The email system uses the keys to connect the emails. We can use them directly. As can see from your snapshot, the two keys in the blue squares are the same. So they are one pair.
Then you can establish relationships between the two tables using the keys. Because you import the sent items and the received items in two tables.
The email systems are different, I can only import all the email in one table. Your scenario is more clear.
Best Regards,
Dale
Thanks for the logic shared!
Please help us how can we calulcate the TAT for each inbox mail from the steps that you shared.
Hi Arek,
Please share me sample PowerBi file in which you have built up this logic to calculate the TAT . I am trying this from past one week and not able to find any solution to my current project.
