Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

How to extract data from text file ?


How to extrect data from text file which is not arrange in a proper format. Say I want to generate 1 report which contains data like Timestamp, username & document name that user downloaded.

All these details are present in a text file.



1 Reply

How to extract data from text file ?

Hi Anta,

You will have to use as many string functions as needed to clean the data until you get exactly what you want. As a general rule, I'd load the whole row as one field, and starting from that, cleaning the data as required. You have in this thread a good example on how hard could become to do this job in QlikView.

Hope that helps.