ITALY IT001 HRGERMANY DE002 HRSPAIN SP03 FINANCEFRANCE FRO04 SALESRefer to the exhibitA company stores the...

Qlik QSDA2021 Question Answer

ITALY IT001 HR

GERMANY DE002 HR

SPAIN SP03 FINANCE

FRANCE FRO04 SALES

Refer to the exhibit

A company stores the employee data within a key composed of Country UserlD, and Department. These fields are separated by a blank space. The UserlD field is composed of two characters that indicate the country followed by a unique code of two or three digits. A data architect wants to retrieve only that unique code.

LTRIM (SUBFIELD (Key, ' ', 2), 2)

MID ( SUBFIELD (Key , ' ', 2), 3)

RIGHT(SUBFIELD (Key,' ', 2), 3)

LEFT(SUBFIELD(Key, ' ', 2), 2)