Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

New to QV. How do I build this table from txt?

I'm a brand new user to QV (just finished the training).  I have never used a BI tool before and this is my first experience. 

How do I build this table? 
I received a daily log file from 20 systems installed in our company.  Each log has details on disk usage only.  They are all prod dev boxes. 
This is the format of the file name ... ibm100.diskdata.Nov01-2011.  Each host has several disks and file systems.  My user wants to build a trend at the file system level to track disk usage.  This is the content of the files:

sunsystem1.diskdata.oct2-2011

filesystem                                   size          used          avail          capacity           diskmount

/folder/filesystem/disk1                    100gb          48gb     52gb          49%               system/data

/folder/filesystem/disk2                     72gb           55gb     17gb          49%               system/data

/folder/filesystem/disk2                     72gb           55gb     17gb          49%               system/data

--

sunsystem1.diskdata.Oct3-2011

(Same data except activity changes in the column files)

Q. How do I capture this daily data in a QV table?

     How do I represent each filesystem per host in a table or chart?

Thanks in adv

0 Replies