Free Preparation Discussions
MENU
Qlik QSDA2024 Exam - Topic 3 Question 20 Discussion
Topic #: 3
A data architect implements Section Access on an app to reduce the data for each user when the user logs in. Each user is allowed to see their specific territory only.
The app is set for a scheduled reload every three hours. Without Section Access added, the app loads successfully. When Section Access is added and the script runs, the app fails to load.
What is causing this issue?
In this scenario, the data architect is using a GENERIC LOAD statement in the script to handle the data structure provided. A GENERIC LOAD is used in Qlik Sense when you have data in a key-value pair structure and you want to transform it into a more traditional table structure, where each attribute becomes a column.
Given the input data table with three columns (Object, Attribute, Value), and the attributes in the Attribute field being either color, diameter, length, or width, the GENERIC LOAD will create separate tables based on the combinations of Object and each Attribute.
Here's how the GENERIC LOAD works:
For each unique object (circle, rectangle, square), the GENERIC LOAD creates separate tables based on the distinct values of the Attribute field.
Each of these tables will contain two fields: Object and the specific attribute (e.g., color, diameter, length, width).
Breakdown:
Table for circle:
Fields: Object, color, diameter
Table for rectangle:
Fields: Object, color, length, width
Table for square:
Fields: Object, color, length
Each distinct attribute (color, diameter, length, width) and object combination generates a separate table.
Final Count of Tables:
The script will create 6 separate tables: one for each unique combination of Object and Attribute.
Qlik Sense Documentation on Generic Load: Generic loads are used to pivot key-value pair data structures into multiple tables, where each key (in this case, the Attribute field values) forms a new column in its own table.
Virgilio
2 months agoSena
2 months agoChantell
3 months agoAdolph
3 months agoSilvana
3 months agoKallie
3 months agoChantell
3 months agoSantos
4 months agoAlesia
4 months agoMelina
4 months agoSharen
4 months agoRosann
4 months agoAlmeta
5 months agoReuben
5 months agoEric
9 months agoMalcom
9 months agoEleni
8 months agoMohammad
8 months agoClemencia
8 months agoAaron
9 months agoKelvin
9 months agoWilletta
9 months agoPilar
9 months agoAndra
10 months agoDiane
8 months agoDoretha
8 months agoFrancoise
9 months agoDerick
9 months agoAshton
9 months agoLeana
10 months agoKeneth
10 months agoTequila
9 months agoGlendora
10 months agoBuck
10 months agoWalker
10 months agoMarva
10 months agoHubert
10 months agoMaryanne
10 months agoHelene
11 months agoWilliam
11 months agoPedro
11 months ago