Free Preparation Discussions
MENU
Qlik QSDA2024 Exam - Topic 4 Question 19 Discussion
Topic #: 4
Exhibit.
While performing a data load from the source shown, the data architect notices it is NOT appropriate for the required analysis.
The data architect runs the following script to resolve this issue:
How many tables will this script create?
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.
Virgina
2 months agoCristy
2 months agoMichal
2 months agoLeontine
3 months agoLaurel
3 months agoIluminada
3 months agoTiara
3 months agoVeronika
4 months agoJeannetta
4 months agoLuz
4 months agoTennie
4 months agoJanessa
4 months agoMatthew
5 months agoJeanice
5 months agoRikki
11 months agoJoni
11 months agoVannessa
11 months agoGlendora
9 months agoDelmy
9 months agoCristina
9 months agoSolange
10 months agoTamesha
11 months agoIra
11 months agoRosamond
10 months agoXuan
10 months agoAnnamae
10 months agoIsreal
11 months agoRikki
11 months agoJoni
11 months agoVerona
11 months agoAide
10 months agoGarry
10 months agoVanda
10 months agoJohnathon
11 months agoFreeman
11 months agoMichell
11 months ago