Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

marko_rakar
New Contributor III

Quick and simple CSV analyzer?

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

Tags (1)
1 Reply

Re: Quick and simple CSV analyzer?

Hi,

maybe you could use some QlikView application to analyze your files like this:

QlikCommunity_Thread_270028_Pic3.JPG

QlikCommunity_Thread_270028_Pic2.JPG

QlikCommunity_Thread_270028_Pic1.JPG

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