let
    Source = Folder.Files("C:\Users\rkman\Downloads\Financial analysis"),
    #"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}, {"stock", type text}, {"endDate", type date}, {"accountsPayable", Int64.Type}, {"inventory", Int64.Type}, {"longTermDebt", Int64.Type}, {"netReceivables", Int64.Type}, {"netTangibleAssets", Int64.Type}, {"longTermInvestments", Int64.Type}, {"totalCurrentAssets", Int64.Type}, {"propertyPlantEquipment", Int64.Type}, {"otherStockholderEquity", Int64.Type}, {"deferredLongTermAssetCharges", Int64.Type}, {"totalCurrentLiabilities", Int64.Type}, {"cash", Int64.Type}, {"otherAssets", Int64.Type}, {"treasuryStock", Int64.Type}, {"goodWill", Int64.Type}, {"otherLiab", Int64.Type}, {"retainedEarnings", Int64.Type}, {"otherCurrentAssets", Int64.Type}, {"commonStock", Int64.Type}, {"totalAssets", Int64.Type}, {"otherCurrentLiab", Int64.Type}, {"deferredLongTermLiab", Int64.Type}, {"totalStockholderEquity", Int64.Type}, {"totalLiab", Int64.Type}, {"capitalSurplus", Int64.Type}, {"intangibleAssets", Int64.Type}, {"shortTermInvestments", Int64.Type}, {"shortLongTermDebt", Int64.Type}, {"minorityInterest", Int64.Type}}),
    #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Source.Name"}),
    #"Replaced Value" = Table.ReplaceValue(#"Removed Columns",null,0,Replacer.ReplaceValue,{"accountsPayable", "inventory", "longTermDebt", "netReceivables", "netTangibleAssets", "longTermInvestments", "totalCurrentAssets", "propertyPlantEquipment", "otherStockholderEquity", "deferredLongTermAssetCharges", "totalCurrentLiabilities", "cash", "otherAssets", "treasuryStock", "goodWill", "otherLiab", "retainedEarnings", "otherCurrentAssets", "commonStock", "totalAssets", "otherCurrentLiab", "deferredLongTermLiab", "totalStockholderEquity", "totalLiab", "capitalSurplus", "intangibleAssets", "shortTermInvestments", "shortLongTermDebt", "minorityInterest"}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Replaced Value",{{"accountsPayable", Currency.Type}, {"cash", Currency.Type}, {"commonStock", Int64.Type}})
in
    #"Changed Type1"