1 Reply Latest reply: Aug 4, 2017 8:13 PM by Marco Wedel RSS

    Quick and simple CSV analyzer?

    Marko Rakar

      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

        • Re: Quick and simple CSV analyzer?
          Marco Wedel

          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