[QLIK AUTOMATION] : using get tabular report not able to assign the name to excel

[Fenil]

Hi,

I am using qlik automation to generate excel and sending in mail, It is generating random numbers, I want to provide the name, I have already given name to template file but still it is generating file like below

Please let me know How I can provide the name.

Thanks,
Fenil Jain

[ineedhelp]

hi can u upload the automation sample 

[Fenil]

Hi @ineedhelp,

Please i have attached just blocks, please check the automation file in attachment.

Thanks,

Fenil Jain

[ineedhelp]

i can't do it through the automation, but in the reporting section (in the app overview menu drop down) you can do it there and we can set the name

[Fenil]

Hi @ineedhelp ,

Yes, at first I was using reporting section and name was coming, But in the mail we wanted to provide dashboard link which is clickable which was not possible there, That's why I am using automation.

Thanks,

Fenil Jain.

[ineedhelp]

I understand ur concept, but a little bit confused, I just tested it.

In the reporting >> create report task >> distribute >> body message >> I input 

https://yourdomainlink/app/your-app-id/overview

Eventhough the link is not clickable in that, but when I sent email, it is actually clickable. 

[Fenil]

Hi @ineedhelp ,

Are you passing any html? or directly link?

because for me it's not working, it is passing me as a link

Thanks,
Fenil Jain.

[Fenil]

Hi @ineedhelp ,

Sorry, made the mistake in writing last sentence, Actually it is passing me as string.

Thanks,

Fenil Jain.

[DY_CB]

The only way to rename a file is to use the Copy File on Microsoft SharePoint block.
In this block you can set a destination path and use the name that you want.

[Amit_Prajapati]

Hi @Fenil ,

To rename an Excel or PDF file before sending it via email, follow these steps:

• If you're using Microsoft SharePoint, use the Copy File block to duplicate the file and assign the new name during the copy process.

• If you're working with Google Cloud Platform (GCP), use the GCS Bucket to copy and rename the file similarly.

• After renaming, use the Open File block to retrieve the updated file.

• Finally, attach the file from the Open File block to the Mail block to send it with the new name.

To include a URL in your email body, use the following HTML format:

<a href="https://www.Qlik.com">Visit Qlik.com!</a>