Hello,

I have a relatively simple task, but I’m currently stuck at one point.

I want to create something similar to an Intervalmatch, but optimized for mapping, as a traditional Intervalmatch would take too long in this case.

I have a mapping table with timestamps, which usually differ only slightly from those in the target table, but in most cases, they almost match. Now, I’d like to define an additional column that maps the correct value from the mapping table to the target table, as long as the timestamp in the mapping table doesn't deviate by more than 10 seconds in the past.

Here’s a sample code to illustrate:

MAPPING_TABLE:
MAPPING LOAD 
 KEY & '-' & Date & '-' & Time,
 Time
 INLINE [
KEY, Date,Time,
1, 22.05.2024,13:10:41
1, 22.05.2024,13:11:40
1, 22.05.2024,13:11:37
];

TABLE2:
LOAD *,
 APPLYMAP('MAPPING_TABLE', KEY & '-' & Date2, 'N/A') AS Time; // Need the correct code here;
LOAD *,
 Time(Time2 - MakeTime(0, 0, 10)) AS TimeDelta
INLINE [
KEY, Date2, Time2
1, 22.05.2024, 13:11:45
1, 22.05.2024, 13:11:41
1, 22.05.2024, 13:11:38
];

My goal is to create the following table:

GOAL_TABLE:
LOAD *
INLINE [
KEY, Date2, Time2, Time,
1, 22.05.2024, 13:11:45, N/A
1, 22.05.2024, 13:11:41, 13:11:40
1, 22.05.2024, 13:11:38, 13:11:37
];

Hopfefully you can support me here.

Best regards Son

Hello, please see the picture below.  I am trying to create a new table that creates a row for each day for each particular machine regardless if that machine had an exam date, and then creating a column in that table that holds the total minutes in that day.  Please help!

Hi All,

I have data with some PII fields. I have three user role which are defined in the section access data with USERID, ROLE field. Three roles are PII,SEMI_PII,NON_PII. In data I have around 3 PII fields. When user with role PII logs in, he should see all PII field values as is. When user with role SEMI_PII logs in, he should see all PII field values partially masked. When user with role NON_PII logs in, he should see all PII field values fully masked. Masking could be anything but masked values should be unique for each field value. for eg. I have Client Name A,B & C, so masked values could be like xAnvBgH, HnbvFTb & hhGVcDr which is unique to each Name as values will be repeating.

Definition of SEMI_PII is that we have indicator in our data, if indicator value is 1 PII fields should be masked, otherwise original values should be displayed. for eg. Let's say we have Client Name A, B & C. for values A & B indicator is1 and for C it is 0. So when user logs in he should see values cHbbVch,BngVbhjK & C. Which means A & B values will be masked.

Note: I have around 1000 users and PII field values for some field might have 5 million distinct values. 

I don't know how to approach this

We have an existing old task that has failed under "error". We did a full reload it works. But after several minutes, the CDC kicks in and we got the error message as below. I have replaced the schema and table name. The rest are the error logs.

Table 'Schema'.'table123' (subtask 0 thread 1) is suspended. Failed to get source column def for ids[0]=6.

The source endpoint is Oracle 11g and target endpoint is MySQL 8 AWS. We are on version 

• November 2022 (2022.11.0.628)

Update:

I am getting this error now.

 Failed to get source column def for ids[2]=1335435064

Hello,

I hope that you can help me.

So basically I have a qvd with Date intervals like 4th August to 10th August, 11th August to 15th August and so on and on...

My goal is to create a datefield in which I can type a date and it should give me the correct interval. Do you know how to create such a visualization?

Thanks for your help!

Hello

I am loading the following table in my Qlik DB without any problem

However, I also have to load the table hereunder and I am a bit stuck.

Is it possible to load those data without modifying the original file?

Many thanks

We have been seeing this error fairly often, for multiple users, in many different locations, on vpn and off vpn.  The error is similar to a timeout but happens while the user is actively working in an app. The message shows at the top of the screen like shown below.

when this error happens, developers sometimes lose the recent changes to the script that they were working on.   we reported this to Qlik support but did not get any resolution, cause or workaround.

Is anyone else seeing this situation in Qlik SAAS or in QCG?
have you found any causes or workarounds?

When i block them it still works fine with oAuth and getAccesstoken.

When i reload Qlik programatically by deleting all the scripts and window objects to refresh the session it doesnt fix any timed out errors. I suspect this cookie causes it.

Hello,

I would like to create a case or to follow an existing Talend case (00316713) :

https://community.qlik.com/t5/Official-Support-Articles/How-to-view-cases-in-Support-Portal/ta-p/1717144

When I select "Manage Cases" I am redirected to :

Could you please tell me how to do that ?

We are paying a platinum support and we are unable to create a simple ticket...

Thanks.