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
Meet Qlik's New CEO. The Future Is Bright — Here's What to Expect
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

Labels (1)
Labels
379 Views
0 Likes
0 Replies
Community Browser