MapAble now provides a simple way to populate tables that are associated with layers in your MapAble workspace. The CASE function is used to provide if-then-else type of logic to SQL. There are two formats: The first is a Simple CASE expression, where we compare an expression to static values. The second is a Searched CASE expression, where we compare an expression to one or more logical conditions. For a full guide to the CASE function click here.