Forum Discussion

chrisgreen5's avatar
chrisgreen5
Frequent Visitor
2 years ago

Email attachments not combining

I am currently trying to combine files from email attachments. I have used this process previously but with these files it is not working.   Below are screenshots of the steps.   1. Exchange onli...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Have you tried deleting the Changed Type step? Or you can click on the white space around the error and see what the value is.

 

--Nate

chrisgreen5's avatar
chrisgreen5
Frequent Visitor
2 years ago

Hi, thanks for the suggestions. I deleted the Changed Type Step but that didn't make any difference. I clicked the white space around the error & got the following: An error occurred in the ‘Transform File’ query. Expression.Error: The key didn't match any rows in the table.
Details:
Key=
Item=2024-04-15
Kind=Sheet
Table=[Table]

What's bizarre is that it always picks 2024 -04 -14 as the sample file but the data shown prior to the error is always from whatever happens to be the most recent file (in this instance from 2024 - 04 - 16) but there doesn't seem to be anyway of altering what it picks as the first or sample file.