Advertisement
Guest User

Untitled

a guest
Jun 26th, 2019
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.29 KB | None | 0 0
  1. Production: 1 = (yes), 0 = (no)
  2. Office: 1 = (yes), 0 = (no)
  3. Storage: 1 = (yes), 0 = (no)
  4.  
  5. CASE WHEN "Production" = 1 THEN 'P' ELSE '' END
  6.  
  7. P/S
  8.  
  9. O/S
  10.  
  11. P/O
  12.  
  13. P/O/S
  14.  
  15. regexp_replace( if("production"=1,'P/','') || if("office"=1,'O/','') || if("storage"=1,'S/',''),'/$','')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement