How to Send a Mail with CSV as Attachment in Automation

[MendyS]

Hi everyone,

I'm trying to send an email using Qlik Automation that includes a table from a Qlik Analytics Dashboard (screenshot attached).

So far, I’ve tried using the "Get Straight Table Data" block, looping through the data, and formatting it with commas or new lines, but I haven’t had much success.

Any guidance or suggestions would be greatly appreciated.

Thanks!

[David_Friend]

@MendyS try doing a 'store into' command, connect to a remote source (like dropbox etc.) then use an automation to schedule the reload of the app containing this load script:

ParquetTest:
LOAD * INLINE [
num, text, mixed
123.321, abc, 123
456.654, def, xyz
789.987, ghi, 321
];
Store ParquetTest into [lib://:Dropbox - name@domain.com/Test/test.csv](txt);

This is just an example!

[salmankojar]

Hi @MendyS you can use Create file block in any of the cloud storage you have access and write first line in it with your header names. Then Use gets straight table data block and inside the loop of that block use write line to CSV file and in data option pass your current item of get straight table block. Outside the loop use save and close file block. After that use open file block to read the same file again and use mail block to send that file as an attachment.