let
    Source = Folder.Files("C:\Users\acer\OneDrive\1 כרם\Docs\עונת 2025\מסמכים שונים\מסמכים מול לכיש\Sidur\SidurProd"),
    #"Filtered Hidden Files1" = Table.SelectRows(Source, each [Attributes]?[Hidden]? <> true),
    #"Invoke Custom Function1" = Table.AddColumn(#"Filtered Hidden Files1", "Transform File", each #"Transform File"([Content])),
    #"Renamed Columns1" = Table.RenameColumns(#"Invoke Custom Function1", {"Name", "Source.Name"}),
    #"Removed Other Columns1" = Table.SelectColumns(#"Renamed Columns1", {"Source.Name", "Transform File"}),
    #"Expanded Table Column1" = Table.ExpandTableColumn(#"Removed Other Columns1", "Transform File", Table.ColumnNames(#"Transform File"(#"Sample File"))),
    #"Changed Type" = Table.TransformColumnTypes(#"Expanded Table Column1",{{"Source.Name", type text}, {"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}, {"Column6", type text}, {"Column7", type text}, {"Column8", type text}}),
    #"Promoted Headers" = Table.PromoteHeaders(#"Changed Type", [PromoteAllScalars=true]),
    #"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers",{{"2025-07-01.HTM", type text}, {"יח'", type text}, {"כמות", type text}, {"מס. אריזות", type text}, {"מספר חלקה", type text}, {"ניקוד איכות", type text}, {"משטח", type text}, {"תאור מוצר", type text}, {"מק""ט", type text}}),
    #"Filtered Rows" = Table.SelectRows(#"Changed Type1", each ([#"יח'"] = "ק'ג")),
    #"Reordered Columns" = Table.ReorderColumns(#"Filtered Rows",{"מספר חלקה", "יח'", "כמות", "מס. אריזות", "ניקוד איכות", "משטח", "תאור מוצר", "מק""ט", "2025-07-01.HTM"}),
    #"Filtered Rows1" = Table.SelectRows(#"Reordered Columns", each ([מספר חלקה] = "5")),
    #"Renamed Columns" = Table.RenameColumns(#"Filtered Rows1",{{"2025-07-01.HTM", "שם קובץ"}}),
    #"Reordered Columns1" = Table.ReorderColumns(#"Renamed Columns",{"שם קובץ", "מספר חלקה", "יח'", "כמות", "מס. אריזות", "ניקוד איכות", "משטח", "תאור מוצר", "מק""ט"}),
    #"Replaced Value" = Table.ReplaceValue(#"Reordered Columns1",".HTM","",Replacer.ReplaceText,{"שם קובץ"}),
    #"Changed Type2" = Table.TransformColumnTypes(#"Replaced Value",{{"שם קובץ", type date}}),
    #"Renamed Columns2" = Table.RenameColumns(#"Changed Type2",{{"שם קובץ", "תאריך"}}),
    #"Changed Type3" = Table.TransformColumnTypes(#"Renamed Columns2",{{"מספר חלקה", Int64.Type}, {"כמות", type number}, {"מס. אריזות", Int64.Type}, {"ניקוד איכות", Int64.Type}, {"משטח", Int64.Type}})
in
    #"Changed Type3"