Hi There I want to load the excel data from specific rows, however i am getting an error stating not able to find the column names. At the moment i am using the below code to read the file. Appreciate your help.

custodian_list:
Load
"col 1" AS "column1",
"col 2" AS "column2",

"col 3" AS "column3",

"col 4" AS "column4",

"col 5" AS "column5",

"col 6" AS "column6",

"col 7" AS "column7",

FROM excelsheet.xlsx', ooxml, embedded labels, table is [CUSTODIAN LIST])
where RecNo()>=5
;
exit Script;

The error i am getting is 

We are trying to do CDC process in qlik with ODBC connection and backend is ProgressDB.

For CDC we found in source connections, under Change processing we have Context Column settings and Expressions to identify Update and Delete Operations.

What is the definition of context column, what if we have all the column at source apart from primary key any non-primary key changes how will qlik identify the changes. Is it possible or do we have to ive update expression.

and if we have to provide update expression please let provide us an example how the update expression.

Thanks,

snigdha

hello everyone,

An error occurred when I was creating a snowflake connection : "Connections are only allowed to *.snowflakecomputing.com hosts. " .

It seems that the official snowflake driver does not support ".cn" ending hosts.

How can I avoid this problem? Do I need to modify the driver configuration file?

We are trying to connect to PostGres SQL database hosted on GCP (Google Cloud Platform). We tried using ODBC connector but GCP does not allow static password for the connection. 

How do we connect to PostGres Database on GCP using QlikSense connector? 

@gcp @postgresSQL @qliksense 

Hi All,

In my project using Qlik Data integration here as Source; Sql server, Target: snowflake

After full load of the DB. Iam getting the below errror. Kindly share your suggestions as soon as possible.

Is there a way to migrate sys.dm_database_encryption_keys from source, to target database?

I have 'always encrypted keys' - column master keys, and column encryption keys in source database. 

However, when I finish the migration, at target, I don't see these information. As well as at target, the "sys.dm_database_encryption_keys" don't have any encryption information. 

お世話になります。

環境は次の通りです QlikSense February 2024 Patch 1

コンボチャートを新たに作成したところ棒部分が細くなってしまいました。

どうやら「線の高さ」を設定するとこうなるようです。

見にくいので前のデザインに戻したいのですが、

「プレゼンテーション」を確認しても

それらしい設定が見当たらなかった為質問させて頂きました。

ご存じの方がおられましたらご教授いただければ幸いです。