Data360 Analyze

Hey, 

I have connected Create Data node with lists of file paths of 3 excel files which I want to send as attachment in email. Then in Send Email node,I have selected the from Field variant of the FilesToAttach property and entered Path as Path is the input field name which holds File paths. I am not sure if I have configured the properties correctly and if there is any workaround for this task? Any recommendation is appreciated.

I think you pretty much have it.

In this example the file names are in the FileName field. Note that in the FilesToAttach property there are no apostrophes around the name and (as you mention) the 'from Field' source option is used.

However, this configuration will send a separate email for each input record and the email will contain the file specified in the FileName field.

If you want to send multiple attachments in a single email then you need to concatenate the filenames into a semicolon-separated list.

You can use a Transform node to perform the concatenation of the strings:

The Send Email node would be configured similar to the previous example but the FileNameList field would be the source of the files to attach.

See the attached example (required Data360 Analyze v.3.6.x)

Attached files

Send_Email_with_Attachments--share - 28 Apr 2021.lna

Hello Adrian,

Your approach is very insightful and helpful.

I tried it with my files but I am getting an error of File not found.

There appears to be something wrong with the path - there are no path separators shown in the error message. 

Check the output of the Create Data node to confirm the strings are correct. When defining strings in the Create Data node you have to escape backslash characters (\) as used in Windows-style paths e.g.