Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2014-07-18 04:49 AM

Mapping

Hi,

How convert below qlickview code to simple SQL

DEPARTMENT_MAP:

MAPPING

LOAD

  ACCOUNT,

  IF(MATCH(UPPER(DEPT), 'RSA', 'NAM', 'ZIM'), Country, 'OTHER')  AS Country

FROM source

225 Views
0 Likes
0 Replies