Discussion Board for collaboration on QlikView Scripting.
Hello I'm working now for one week with Qlikview and need your help. I have a Textfile with this structure:
20110929 (next Datestring)
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.
You can use the Previous() function to populate current record value with previous value
LOAD *, If(Len(Datastring) = 0, Previous(Datastring), Datastring)) AS DatastringFROM File.txt;
If(Len(Datastring) = 0, Previous(Datastring), Datastring)) AS Datastring
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
Comex Grupo Ibérica
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.