Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
marko_rakar
Creator
Creator

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

1 Reply
MarcoWedel

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