Question 5
Refer to the exhibits.
The first table, Mastersports, contains the master list of all sport names that need to be loaded into the app. The second table, TeamMembers, contains the teams and team members registered for specific sports.
In a Qlik Sense app, a data architect is loading the two tables that need to be linked together based on the Sport field. The table format cannot be changed in the source.
What should the data architect do in the data load editor?
Apply a preceding LOAD from the TeamMembers table with the SUBFIELD function and rename the field to Sport
Apply a preceding LOAD to the MasterSports table with the SUBFIELD function to create the Sport field
Apply a FOR loop to load to the MasterSports table creating the values for the Sport field
Correct answer: C