Forum Discussion
Criamon
7 years agoFrequent Visitor
Retaining email metadata when aggregating attachments.
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
1 Reply
- ImkeFCommunity Champion
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.