topic Import data from Textfile in QlikView

Import data from Textfile

Thu, 20 Oct 2011 10:15:42 GMT

Hello I'm working now for one week with Qlikview and need your help. I have a Textfile with this structure:

20110930 (Datestring)

Datastring1 (Datastrngs)

Datastring2

Datastring3

20110929 (next Datestring)

Datastring4 (Datastrngs)

Datastring5

...

Now I want to import the Data like this:

Datestring | Datastring

-----------------------------------------------

20110930 | Datastring1

20110930 | Datastring2

20110930 | Datastring3

20110929 | Datastring4

20110929 | Datastring5

I tryed many things but failed.

Thaks for your ideas.

Re: Import data from Textfile

Miguel_Angel_Baeyens — Thu, 20 Oct 2011 10:27:10 GMT

Hi,

You can use the Previous() function to populate current record value with previous value

LOAD *,
     If(Len(Datastring) = 0, Previous(Datastring), Datastring)) AS Datastring
FROM File.txt;

If the field is empty, take the value from previous record, if it's not empty, take the current value.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: Import data from Textfile

Thu, 20 Oct 2011 12:08:09 GMT

Hi,

I have only one field. Now I have uploaded the file as attachement to understand the problem better.

Each line is a call and I want from every call the number which are the xxxxxxxxx and the date from the top. To get the phonenumber is no problem for me but i can't add the date to each call.

Thanks for your fast answer of the first post.