How to generate a summary average of multiple csv files?

[#1]

I have multiple csv files in the attached format in a particular folder , how do I generate a new file which contains the summary of the average of all the columns A, B, C, D of each csv file in the below format:

filename	A	B	C	D
	avg_colA_file1	avg_colB_file1	avg_colC_file1	avg_colC_file1
	avg_colA_file2	avg_colB_file2	avg_colC_file2	avg_colC_file2

I know to generate the average of each csv file using table summary but how can we do the same for multiple csv files using a single script?

[#2]

Sure but I could not find my answer there because close( dtx, nosave ); closes both the data table and summary table. I wanted to close only the data table & keep the summary table open, is that possible?

[#3]

The reason for it closing the summary table is that you specified to Link the summary table to the original table. Change or add
Link to Original Data Table(0)

[#4]

Thanks a lot really appreciate your inputs!

[#5]

Did you try if Tables -> Summary function is doing the job you want?