Free Preparation Discussions
MENU
Qlik QSDA2024 Exam - Topic 1 Question 18 Discussion
Topic #: 1
A data architect executes the following script:
What will be the result of Table.A?
A)
B)
C)
D)
In this scenario, the key is composed of three components: Country, UserID, and Department, separated by spaces. The UserID itself consists of a two-character country code followed by a unique code of two or three digits. The objective is to extract only this unique numeric code from the UserID field.
Explanation of the Correct Function:
Option A: RIGHT(SUBFIELD(Key, ' ', 2), 3)
SUBFIELD(Key, ' ', 2): This function extracts the second part of the key (i.e., the UserID) by splitting the string using spaces as delimiters.
RIGHT(..., 3): After extracting the UserID, the RIGHT() function takes the last three characters of the string. This works because the unique code is either two or three digits, and the RIGHT() function will retrieve these digits from the UserID.
This combination ensures that the data architect extracts the unique code from the UserID field correctly.
Ranee
4 months agoStephania
4 months agoCasie
4 months agoMila
4 months agoCristy
5 months agoJesus
5 months agoCherry
5 months agoEvelynn
5 months agoShoshana
6 months agoReita
6 months agoCecil
6 months agoZack
6 months agoShawnee
6 months agoJohana
11 months agoTrinidad
10 months agoElise
10 months agoMalinda
10 months agoDenny
11 months agoLavonna
10 months agoMarylou
10 months agoReuben
10 months agoGlendora
10 months agoCheryl
11 months agoKristel
11 months agoLucina
12 months agoLeslee
12 months agoDeandrea
10 months agoNan
11 months agoFidelia
11 months agoStephaine
11 months agoCarmelina
1 year agoGalen
1 year agoCarmelina
1 year ago