Weitere Formelbeispiele

Schularten anpassen

BBS

Schulart zu BBS zusammenfassen:

• Spaltenname "D" anpassen!

  CASE
       WHEN D like 'BGY%' THEN 'BBS'
       WHEN D like 'BS/BS%' THEN 'BBS'
       WHEN D like 'BS/BGJ%' THEN 'BBS'
       WHEN D like 'BS/gBVJ%' THEN 'BBS'
       WHEN D like 'BS-F/BS (v)%' THEN 'BBS'
       WHEN D like 'BFS/BFS (v)%' THEN 'BBS'
       WHEN D like 'BFS/BFS (t)%' THEN 'BBS'
       WHEN D like 'FS/FS (v)%' THEN 'BBS'
       WHEN D like 'FS/FS (t)%' THEN 'BBS'
       WHEN D like 'FOS/FOS%' THEN 'BBS'
       WHEN D like 'BS-F/kBVJ%' THEN 'BBS'
       WHEN D like 'BS/BVJ%' THEN 'BBS'
       WHEN D like 'BS/VK%' THEN 'BBS'
       WHEN D like 'BS-F/BvB%' THEN 'BBS'
       WHEN D like 'BS/BvB%' THEN 'BBS'
       WHEN D like 'BS-F/BS%' THEN 'BBS'
       WHEN D like 'BS-F/BVJ%' THEN 'BBS'
   END

Anpassen der Schularten an die Bögen in Phönix

CASE WHEN I like '%/BS' THEN 'BS' WHEN I like '%/BGJ' THEN 'BGJ' WHEN I like 'BS/VK' THEN 'VK' WHEN I like '%BVJ' THEN 'BVJ' WHEN I like '%/EQ' tHEN 'BVM' WHEN I like '%/BvB' THEN 'BVM' WHEN I like 'FS/%' THEN 'FS' WHEN I like 'FOS/%' THEN 'FOS' WHEN I like 'BFS/%' THEN 'BFS' WHEN I LIKE 'BGY' THEN 'BGY' END

ABS

B2 zu OS und GYM zuordnen:

• Spaltenname "E" anpassen!

  CASE
       WHEN E like 'GS%' THEN 'GS'
       WHEN E like 'OS%' THEN 'OS'
       WHEN E like 'B2:OS%' THEN 'OS'
       WHEN E like 'GYM%' THEN 'GYM'
       WHEN E like 'B2:GYM%' THEN 'GYM'
       WHEN E like 'B2:KOL%' THEN 'GYM'
       WHEN E like 'AFS%' THEN 'AFS'
       WHEN E like 'P63%' THEN 'P63'
       WHEN E like 'GMS%' THEN 'GMS'
       WHEN E like 'BBS%' THEN 'BBS'
   END