== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (14)
+- Project (13)
+- Project (12)
+- Project (11)
+- Project (10)
+- Project (9)
+- Project (8)
+- Project (7)
+- Project (6)
+- Project (5)
+- Project (4)
+- LogicalRelation (3)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `DIAGNOSTIC_PE1__187951171`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: parquet, [Code+CIM+10#721705, Libell%C3%A9+long#721706, Date_effet#721707, Date_r%C3%A9vocation#721708, Responsable+MAJ#721709, Source#721710, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#721711], false
(4) Project
Arguments: [Code+CIM+10#721705 AS Code CIM 10#721728, Libell%C3%A9+long#721706, Date_effet#721707, Date_r%C3%A9vocation#721708, Responsable+MAJ#721709, Source#721710, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#721711]
(5) Project
Arguments: [Code CIM 10#721728, Libell%C3%A9+long#721706 AS Libellé long#721737, Date_effet#721707, Date_r%C3%A9vocation#721708, Responsable+MAJ#721709, Source#721710, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#721711]
(6) Project
Arguments: [Code CIM 10#721728, Libellé long#721737, Date_effet#721707 AS Date_effet#721745, Date_r%C3%A9vocation#721708, Responsable+MAJ#721709, Source#721710, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#721711]
(7) Project
Arguments: [Code CIM 10#721728, Libellé long#721737, Date_effet#721745, Date_r%C3%A9vocation#721708 AS Date_révocation#721753, Responsable+MAJ#721709, Source#721710, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#721711]
(8) Project
Arguments: [Code CIM 10#721728, Libellé long#721737, Date_effet#721745, Date_révocation#721753, Responsable+MAJ#721709 AS Responsable MAJ#721768, Source#721710, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#721711]
(9) Project
Arguments: [Code CIM 10#721728, Libellé long#721737, Date_effet#721745, Date_révocation#721753, Responsable MAJ#721768, Source#721710 AS Source#721776, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#721711]
(10) Project
Arguments: [Code CIM 10#721728, Libellé long#721737, Date_effet#721745, Date_révocation#721753, Responsable MAJ#721768, Source#721776, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#721711 AS DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#721784]
(11) Project
Arguments: [Code CIM 10#721728 AS Code CIM 10#721799, Libellé long#721737 AS Libellé long#721800, Date_effet#721745 AS Date_effet#721801, Date_révocation#721753 AS Date_révocation#721802, Responsable MAJ#721768 AS Responsable MAJ#721803, Source#721776 AS Source#721804, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#721784 AS DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#721805]
(12) Project
Arguments: [Code CIM 10#721799, Libellé long#721800, Date_effet#721801, Date_révocation#721802, Responsable MAJ#721803, Source#721804, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#721805]
(13) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#721799, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_187952#721826, str_to_datez(Date_effet#721801, M/d/yy, null, null) AS DATE_EFFET_187954#721821, str_to_datez(Date_révocation#721802, M/d/yy, null, null) AS DATE_REVOCATION_187955#721822, Libellé long#721800 AS LIBELLE_LONG_187953#721823, Responsable MAJ#721803 AS RESPONSABLE_MAJ_187956#721824, Source#721804 AS SOURCE_187957#721825]
(14) Project
Arguments: [CODE_CIM_10_187952#721826, DATE_EFFET_187954#721821, DATE_REVOCATION_187955#721822, LIBELLE_LONG_187953#721823, RESPONSABLE_MAJ_187956#721824, SOURCE_187957#721825, str_remove_space(str_remove_extend(CODE_CIM_10_187952#721826, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_187958#721833]