Skip to main content

Qlik

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
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
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

179 Views
0 Likes
0 Replies