Just to make it clear - in real life you will actually have two separate datasources and not single file with different sheets, correct?
Yes, in real life I have 1 sql server data source and the other is excel (which contains the incident details). Thanks.
Sent from my iPhone
Well, blending does not really help since you need left join functionality (ugh, you might try to have all the dates in Excel to sort of mimic inner join).
You can get creative: https://support.microsoft.com/en-us/kb/306397
Or, if data on SQL server is not too big - check out new "cross-database joins" feature that's coming in 10.0