Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Pivot tables don't seem to be working properly with the "Page" feature in nPrinting Excel reports.
To reproduce it:
Let's say you are iterating over field MYFIELD and values are MF1, MF2, MF3 and MF4. In this case, nPrinting will clone your sheet 4 times and they will be called MF1, MF2, MF3 and MF4.
The fixed table will be present in all sheets and the pivot table as well. However, in ALL sheets, the pivot table will point to the fixed table in sheet MF1 (the first one).
In this case, the expected behavior is for nPrinting to generate 4 sheets (MF1, MF2, MF3 and MF4), each sheet will have a copy of the fixed table and each sheet will have a pivot table using as data source the fixed table from the same sheet.
I understand in 2017 there was an issue (Jira issue OP-5657), which was fixed, related exactly to the issue of mixing "Page" with pivot tables (see release notes for nPrinting November 2017).
So, is this supposed to work as I expect it to? Is this an error? Is it a "feature"? (maybe @Andrew_Kruger or @Gianluca_Perin can help?).
Thanks a lot for your help!
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) :
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.
Pencil in our most magical conference yet: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL
Fuel your data and AI journey with the right services, delivered by our experts.
With Qlik Answers™, get personalized, GenAI-driven answers from unstructured data, so you can make decisions with confidence. Learn how in our product roadmap keynote and demo.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.
Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.
Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!