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 

I have a Pivot Table with two dimensions the PLACE in the Y Axis and The Week on the X Axis.

The Function is like Sum ({<Place, Week>} Weight)

I colored the background of each Name of The dimension PLACE with a different color and with the Function:

Pick(Match(Place,'A','B','C'), red, green, yellow )

Why when i Select a value in the pivottable the colors disappear?

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.