How to create an Excel report using Snowflake as a data source in Mail & Deploy (with example)?
| FIRST CREATED ON 5 Mar 2024 I AUTHOR Emma Camacho |
Creating an Excel report using Snowflake as a data source in Mail & Deploy allows you to leverage powerful data analysis capabilities. Here's an example to help you get started:
Use case: Display Orders and Orders' Line items from one Customer from the Snowflake sample database
Here are the Snowflake tables:
CUSTOMER
ORDERS
LINEITEM
Mail & Deploy Report
How to get there?
Snowflake Server Database datasource
Report Template
Customer and the corresponding Orders
Orders and the corresponding Line items
PARAMETERS
Customer
The Customer number is a parameter, for design purposes, the default is set to 270001
CUSTOMER element
ORDERS element
ORDERS Repeater Element
Preparation Action
ORDERS Repeater Element
Levels
LINEITEM Element
Looking for Additional Guidance?
If you require more detailed information or further assistance, please visit our comprehensive Online Documentation. Our resources are designed to help you navigate all features and functionalities effectively.
Related Articles
How to synchronize cell insertion in an Excel report in Mail & Deploy (with example)?
FIRST CREATED ON 31 Jan 2024 I AUTHOR Emma Camacho Synchronizing cell insertion in an Excel report within Mail & Deploy ensures that your data is accurately aligned and formatted. Here's an example to guide you through the process: If you need a ...Creating Custom Calculations in Excel Reports Using Mail & Deploy?
You want to create an Excel report using Mail & Deploy. Specifically, you have a table spanning columns A to K and need Column G to display the result of Column I × Column B, instead of using the result directly from the Qlik app. Solution: While the ...What is Report Culture Awareness, and how does it impact Mail & Deploy reports?
FIRST CREATED ON 30 Apr 2020 I AUTHOR Emma Camacho A culture is a set of rules that specify how numbers and dates are formatted (Windows Regional Settings). Generally speaking, the culture defines in what format numbers and dates are being presented ...How to Cycle Through a Chart with a Variable as a Dimension in a Mail & Deploy PowerPoint Report?
You wish to cycle through a chart in a Mail & Deploy PowerPoint report where the dimension is defined by a variable. Manually assigning values to the variable on each slide did not work as expected. Solution: Instead of manually assigning values, you ...How to activate Qlik Sense Themes in Mail & Deploy?
FIRST CREATED ON 14 Jun 2023 I AUTHOR Emma Camacho Qlik Sense themes offer a powerful way to customize the appearance of your reports. By applying themes, you can easily align the look and feel of your reports with your brand or preferred style. ...