Greetings!

I tried to replicate views from the Source SQL Server RDS to Snowflake and what I am seeing is that the Views are replicating as Tables.

Can anyone suggest how to replicate Views as Views and not as Tables in the Target?

Thanks!

Satyender

I have an app, 1st sheet has 4 filters: year, month, type, department. after I selected filters, sheet 1 will jump to sheet 2 , and keep all the filters. and I want to have a line chart to show the score changes by year. 

but year has selected at the beginning, so the line chart cannot show the X ray with full year. the other 3 filter must keep, then  I will set avg of score. 

the question is: how can I skip the year filter, and keep others, calculate the avg with the other 3 filters.

besides, the ray may be year, may be month, depends on the type filtered. could it be possible to change automatically?

I need to move files from a Box folder to a local drive. This should be an easy process with 3 components: tBoxv2Connection, tBoxv2List, tBoxv2Get. I created the integration with configurations to match the components in this example https://help.talend.com/en-US/components/8.0/box/tboxconnection-tboxput-tboxget-configuring-components-standard-component 

I can run the connection and list to return a list of files in the box folder. I've tried the Get component using the folder path in box or the box file ID. I'm simply dropping the file in "C:/Test".  

I finally broke down and simply hardcoded the file paths in both fields of the Get component and got this error message: "org.talend.components.box.get.BoxGet- A problem occurred during reading data from Box"

Any idea what is causing this issue?

I would like to use SnowSQL to put data in a Snowflake stage using Qlik Sense Execute. I have made a script that works in command line from my server, but when i run it via Execute in a Qlik Sense App's script, the load gets hung. I've come up with a simple example that should be working, but is getting hung. Does anyone have any ideas?

Here is the simple example with and without double quotes that wont work:

Execute cmd c/ snowsql -v > d:/output_file.csv;

Execute cmd c/ "snowsql -v > d:/output_file.csv";

Here is an example of the PUT command that is also not working:

snowsql -c my_connection -q "PUT 'file:////fileshare path/data.csv' @snowflake_DB.SNOWFLAKE.SNOWFLAKE_STAGE OVERWRITE = TRUE"

Please let me know if you've accompished this and have any ideas why its not working.

Hello!  I'm getting an error when hitting the generate new app button using the navigation link.  I have the detail template app created, and the selection high level app created, with the navigation link set up, it's generating the template app but not recognizing the selections made and also throws an error " Reload error : (Connector error:  ERROR [42000] SQL Compilation error:  syntax error line 61 at position 0 unexpected 'AND'.).

I know it has something to do with my sql in the detail template app but am having no luck fixing it.  Attached is a document with screenshots of everything.  I'm sooooo close to getting this working, please help!  I truly appreciate it.  Thank you in advance!

Greetings!

Does Qlik plan to develop the equivalent of an Advanced Analytics Connector for Qlik Cloud that could be used to invoke ML models deployed in Snowpark ML???

Cheers,

++José

Hi guys. I have a question regarding Qlik Application Automation. I have a sheet that contains a table of two columns, "Name" and "CampaignName". I also have a filter button to filter out "Name". If you filter for one "Name", the table updates to five "CampaignNames". Is there a way to use the data found in a sheet inside a condition loop on Qlik Application Automation?