Hello

I have problem with synth keys. Im trying to solve it by preparing key but it won't work.

Here's my data:

LOAD
ORDER_NO as PROD_ORDER_NO,
SEQ as QM_PROD_SK_SEQ,
TT_NO as PTT,
RESULTS1

RESULTS2

RESULTS3 ...

2nd table

ORDER_NO as PROD_ORDER_NO,
SEQ as QM_PROD_SK_SEQ,
TT_NO as PTT,
DIF_RESULTS1

DIF_RESULTS2

DIF_RESULTS3 ...

How to prepare a key which will connect PTT and PROD_ORDER_NO without syth key, so that i will still be able to use PTT or PROD_ORDER_NO filter? 

I am loading sales figures from a data set that now includes obsolete items. How do I prevent the items from loading  in the script where the item number is 'Obsolete' 

Sales_Data:

LOAD
Store_Number,

Item_Number,
Item_Category,

Thanks!

Hi, I want to retrieve columns from the following xml

The following is the column structure and xml

I get an error like below

Am I wrong in the xpath?
or is there a difference in the xpath if the column is a string or an integer?

Hi Team

We are getting below error in a task.

Could you please help us with the same.

Task Name replication task encountered the following error:
Creating Metadata Manager's utility components failed Cannot create the target utility component failed while preparing stream component 'Task Name'.
Cannot connect to SQL Serv
Ret Code: SQL_ERRO SqlState:08001 Native Error:- 2146893022 Message:[Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: The target principal name is incorrect.

Regards,

Megha

Hi everyone,

I've tried searching for hours to answer a client's request

Is it possible to modify password policy in QlikSense Enterprise (on premise)?

Modifying minimum length, special character, number, expiration duration, etc

The client has it's own password policy, so that they need to make sure Qlik Sense Enterprise on Windows could comply with it

Please keep in mind that Qlik Sense cloud is not an option

Integration with user directory such as ActiveDirectory is not available. So it is only native Qlik user account

I'm not yet found a clear statement in the community regarding the possibility

Thank you in advance

Regards,

Ariza

Hi, I'm trying to connect SharePoint via Qlik Sense. Below steps i followed, 

1. Creating a new data connection. 

2. Choosing  the data source "Office 365 Sharepoint"

3. Then given the base URL of Office 365 Sharepoint in the baseURL.

4. Then choose the "None" from Prompt/Consent level. 

5. Click on Authenticate button. Then it will take to next tab and code generated. Then copied code and paste in the respective tab. Then clicked on the Authenticate tab. 

6. After that taking some time and faced the error. Below is the error message,

"error verifying: A connection attempt failed because the connected party did not properly respond after a period of time or established connection failed because connected host has failed to respond "Some IP (1.1.1.1:443)"

kindly suggest

Hi,

I want to download private files related to an opportunity in Salesforce. I've tried tfileFetch but it doesn't work.
I've tried using APIs but I can't make the link between the opportunity and the file to be uploaded to Salesforce.
Have you ever had this problem? Do you know how to retrieve these files? 

Thanks