Retaining email metadata when aggregating attachments.

[Criamon]

Hello all.  

I've got a PQ script that's aggregating multiple excel attachments from multpile emails (in a given folder).  So when I combine binaries, all the other email information columns aren't retained.  What I'd like to do is add the sender and timestamp as columns in my aggregated data so a record can be back-tracked to the original email.  Is this possible when combining binaries like this?

Thanks,

-Chris

[ImkeF]

That's fairly easy to do: Just edit the step "Removed Other Columns" like described here: https://www.excelguru.ca/blog/2016/12/21/new-combine-binaries-experience/ and choose the columns you want to keep.