Thanks for the great post.

I am extracting data (through power query) from multiple .csv files. These individual .csv files (262 of them) are dynamically updated from one of the trading platform.
So one new row is appended for every 15 minutes in each of the .csv files (different stock symbols).

What I want is to maintain the same number of rows for each of these .csv files. In other words, as data (row) get appended to each of these .csv files, the number of rows keeps on increasing until end of the day and the following day the same routine. While I am aware of the Keep Bottom Rows, how can i do this for individual files (262 of them) through power query.

Here is the query :

let
Source = Folder.Files("C:Yogya Data CollectionData Between Dates"),
#"Split Column by Delimiter" = Table.SplitColumn(Source, "Name", Splitter.SplitTextByDelimiter(".", QuoteStyle.Csv), {"Name.1", "Name.2", "Name.3"}),
#"Removed Other Columns" = Table.SelectColumns(#"Split Column by Delimiter",{"Name.1", "Content"}),
#"Renamed Columns" = Table.RenameColumns(#"Removed Other Columns",{{"Name.1", "Symbol"}}),
#"Invoked Custom Function" = Table.AddColumn(#"Renamed Columns", "Transform File", each #"Transform File"([Content])),
#"Removed Columns" = Table.RemoveColumns(#"Invoked Custom Function",{"Content"}),
#"Expanded Transform File" = Table.ExpandTableColumn(#"Removed Columns", "Transform File", {"Date", "Time", "Open", "High", "Low", "Close", "Volume"}, {"Transform File.Date", "Transform File.Time", "Transform File.Open", "Transform File.High", "Transform File.Low", "Transform File.Close", "Transform File.Volume"}),
#"Renamed Columns1" = Table.RenameColumns(#"Expanded Transform File",{{"Transform File.Date", "Date"}, {"Transform File.Time", "Time"}, {"Transform File.Open", "Open"}, {"Transform File.High", "High"}, {"Transform File.Low", "Low"}, {"Transform File.Close", "Close"}, {"Transform File.Volume", "Volume"}})
in
#"Renamed Columns1"

Any help would be highly appreciated.

Much Regards,
~GK