| 12345678910111213 |
- select T1."EBENE21" as "Ebene21",
- T1."EBENE22" as "Absatzkanal_mit_Bez",
- T1."EBENE23" as "Ebene23",
- T1."EBENE24" as "Ebene24",
- T1."EBENE25" as "Ebene25",
- T1."EBENE26" as "Ebene26",
- T1."EBENE27" as "Ebene27",
- T1."EBENE28" as "Ebene28",
- T1."EBENE29" as "Ebene29",
- T1."EBENE30" as "Ebene30",
- CASE WHEN (T1."EBENE22" IN ('100 - Bilanz')) THEN ('100') ELSE ((left(T1."EBENE22",2))) END as "Absatzkanal"
- from "Absatzkanal.csv" T1
- where ((CASE WHEN (T1."EBENE22" IN ('100 - Bilanz')) THEN ('100') ELSE ((left(T1."EBENE22",2))) END) BETWEEN '00' AND '99')
|
