<!DOCTYPE EasyDataTransform>
<root>
    <meta>
        <version value="85"/>
        <last_saved_by value="Olaf_W%C3%BCllenrath_using_Easy_Data_Transform_Advanced_v2_13_0_on_macOS_26_5_arm64_at_2026_05_22_17_44_16"/>
        <locale value="de_DE"/>
        <id value="7b77050b357607070b777a74080a3c00"/>
        <snap_to_grid value="1"/>
        <notes/>
        <doc_path value="%2FUsers%2Folaf%2Ftmp%2FGather%20with%20months.transform"/>
        <auto_run_on value="1"/>
    </meta>
    <inputs>
        <input pos="-329.4^-164.7" ignored_rows="0" show_meta="0" json_arrays_as_rows="0" delimiter="0" ignore_excel_hidden_cols="0" schema_in_use="0" name="File1%20for%20gather.csv" schema_extra_cols="0" pos_v12="-329.4-164.7" watching="0" medium="0" auto_fixed_widths="1" path="%2FUsers%2Folaf%2Ftmp%2FFile1%20for%20gather.csv" header="1" schema_missing_cols="0" ignore_empty_cols="0" schema_reorder_cols="0" trim="1" meta_col_name="Meta%20Info" file_type="0" id="0" alias="File1%20for%20gather" custom_delimiter="%2A" ignore_repeated_delim="0" meta_text="%24%28FileSheetName%29" ignore_excel_hidden_rows="0" ignore_empty="1" encoding="Automatic" quote="0" simplify="1"/>
        <input pos="-329.4^-45" ignored_rows="0" show_meta="0" json_arrays_as_rows="0" delimiter="1" ignore_excel_hidden_cols="0" schema_in_use="0" name="Clipboard" schema_extra_cols="0" pos_v12="-329.4-45" watching="0" medium="1" auto_fixed_widths="1" header="1" schema_missing_cols="0" ignore_empty_cols="0" schema_reorder_cols="0" trim="0" meta_col_name="Meta%20Info" file_type="0" id="3" custom_delimiter="%2A" ignore_repeated_delim="1" text="Prod%2CProduct%20A%2CProduct%20B%2CProduct%20C%2CProduct%20D%2CProduct%20E%2CProduct%20F%2CProduct%20G" meta_text="%24%28CurrentDateTime%29" ignore_excel_hidden_rows="0" ignore_empty="0" encoding="Automatic" quote="0" simplify="0"/>
    </inputs>
    <transforms>
        <transform id="1" name="Gather" pos="-90^-164.7" pos_v12="-90-164.7">
            <parameters>
                <parameter type="1" name="Columns" value="234567891011"/>
                <parameter type="7" name="Key_Column" value="Month"/>
                <parameter type="7" name="Value_Column" value="Value"/>
            </parameters>
        </transform>
        <transform id="2" name="Transpose" pos="-90^74.5313" pos_v12="-9074.5313">
            <parameters>
                <parameter type="5" name="Header" value="1"/>
            </parameters>
        </transform>
        <transform id="4" name="Stack" pos="149.4^74.5313" pos_v12="149.474.5313">
            <parameters>
                <parameter type="6" name="Align_Cols" value="Header%20name"/>
                <parameter type="5" name="Only_First_Cols" value="0"/>
                <parameter type="5" name="Add_Separators" value="0"/>
                <parameter type="7" name="User_Defined_Row_Value" value="---"/>
            </parameters>
        </transform>
        <transform id="5" name="Gather" pos="628.2^74.7" pos_v12="628.274.7">
            <parameters>
                <parameter type="1" name="Columns" value="2345678"/>
                <parameter type="7" name="Key_Column" value="Product"/>
                <parameter type="7" name="Value_Column" value="Value"/>
            </parameters>
        </transform>
        <transform id="6" name="Reorder" pos="867.6^74.5313" pos_v12="867.674.5313">
            <parameters>
                <parameter type="4" name="Columns" value="213"/>
            </parameters>
        </transform>
        <transform id="7" name="Rename_Cols" pos="388.8^74.7" pos_v12="388.874.7">
            <parameters>
                <parameter type="13" name="RenameColumns" value="Month%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A"/>
            </parameters>
        </transform>
        <transform id="8" name="Filter" pos="1107^74.7" pos_v12="110774.7">
            <parameters>
                <parameter type="3" name="Columns" value="11320"/>
                <parameter type="5" name="Case_Sensitive" value="0"/>
                <parameter type="5" name="Disable" value="0"/>
            </parameters>
        </transform>
    </transforms>
    <outputs/>
    <charts/>
    <notes>
        <note id="9" comment="complete%20list%20of%20procucts" pos_v12="-568.8-45" color="255%1F255%1F255" arrow="2"/>
        <note id="10" comment="ensure%20with%20the%20stack%20that%20all%20product%20columns%20do%20exist" pos_v12="149.4-45" color="255%1F255%1F255" arrow="3"/>
        <note id="11" comment="rename%20the%20Prod%20column%20to%20Month%20after%20the%20transpose" pos_v12="388.8-45" color="255%1F255%1F255" arrow="3"/>
        <note id="12" comment="Gather%20should%20now%20be%20stable%20if%20the%20product%20list%20doesn%27t%20change%20" pos_v12="628.2-45" color="255%1F255%1F255" arrow="3"/>
        <note id="13" comment="order%20columns%20in%20sequence%20as%20created%20by%20the%20original%20gather" pos_v12="867.6-45" color="255%1F255%1F255" arrow="3"/>
        <note id="14" comment="remove%20all%20rows%20without%20value" pos_v12="1107-45" color="255%1F255%1F255" arrow="3"/>
    </notes>
    <connections>
        <connection start_id="0" end_id="1"/>
        <connection start_id="0" end_id="2"/>
        <connection start_id="2" end_id="4"/>
        <connection start_id="3" end_id="4"/>
        <connection start_id="4" end_id="7"/>
        <connection start_id="5" end_id="6"/>
        <connection start_id="6" end_id="8"/>
        <connection start_id="7" end_id="5"/>
    </connections>
    <batch_values/>
    <batch_logging verbosity="2" enabled="0" mode="0"/>
</root>
