topic Quick and simple CSV analyzer? in QlikView

Quick and simple CSV analyzer?

marko_rakar — Thu, 03 Aug 2017 15:11:06 GMT

(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

Re: Quick and simple CSV analyzer?

MarcoWedel — Sat, 05 Aug 2017 00:09:01 GMT

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