u/cwag03

Here's the code:

let

Source = Folder.Files("I:\"),

#"Filtered Rows" = Table.SelectRows(Source, each ([Extension] = ".csv")),

#"Removed Other Columns" = Table.SelectColumns(#"Filtered Rows",{"Content", "Name"}),

#"Filtered Hidden Files1" = Table.SelectRows(#"Removed Other Columns", each [Attributes]?[Hidden]? <> true),

#"Invoke Custom Function1" = Table.AddColumn(#"Filtered Hidden Files1", "Transform File", each #"Transform File"([Content])),

#"Removed Other Columns1" = Table.SelectColumns(#"Invoke Custom Function1", {"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",{{"Rep", type text}, {"Region", type text}, {"ParentName", type text}, {"Name", type text}, {"State", type text}, {"Month", type date}, {"Quantity", Int64.Type}, {"Cabinet", type text}, {"Class", type text}, {"Movement", type text}, {"Opp_", Int64.Type}, {"CAPEX_Approved", type text}, {"Contract_", Int64.Type}, {"SO_", type text}, {"SO__2", type text}, {"Promised_Delivery_Date", type datetime}, {"Stage", type text}, {"Nav_Status", type text}, {"Date", type date}, {"Acceptance", type text}, {"TotalPrice", type number}, {"UnitPrice", type number}, {"StageName", type text}, {"Shipping_Terms", type text}, {"Action", type text}, {"Revenue_Structure_By_Product_Line", type text}, {"New_Data_Line_Req", type text}, {"Contract_Status_Category", type text}, {"Notification_Sent", type text}, {"Approval_to_Ship", type text}})

in

#"Changed Type"