Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
(sorry if this is in wrong place)
I have a project wich comes with literally hundreds of tables in form of various CSV files.
Is there some utility which can go through selected files and give me basic stats (number of rows/fields, min/max/avg values)?
Something quick and dirty, nothing fancy just so I get overview what is inside.
thanks
Hi,
maybe you could use some QlikView application to analyze your files like this:
tabCSVFiles:
CrossTable (Field, Value, 2)
LOAD FileName() as File,
RecNo() as RecNo,
*
FROM [QlikCommunity_Thread_270028_*.csv] (txt, utf8, embedded labels, delimiter is ',', msq);
(you could limit the loaded rows e.g. by appending "Where RecNo()<1000" to the load)
hope this helps
regards
Marco