Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Load problem

i have this situation

idfromto
202/01/2012
303/01/201204/01/2012
404/01/201209/01/2012 ID 2 TWO NULL
305/01/2012
306/01/201209/01/2012 ID 3 TWO NULL
207/01/201207/01/2012
208/01/2012
409/01/2012 ID 4 NULL ONLY ONE
310/01/201211/01/2012
311/01/2012

i NEED TO LOAD IF IS NULL WITH WHERE BUT SOME TIMES ORIGNAL DATA IS BAD.

How to load only the last null ??

regards..

3 Replies
MVP
MVP

Re: Load problem

please could you explain the rule to identify nulls?

or mark the records you want to load?

Not applicable

Re: Load problem

i need load all records.

i have not rule. some records has more than one null (data base is wrong)

if i has 2 null the las is the valid the other is from-1.

example.

10/01/2012     null(14/05/2012 will be)

15/05/2012       null

regards

dirk_konings
Contributor III

Re: Load problem

Hi,

I think you have to load the data in descending order by id and from date

Then you could work with previous() function to get the 'from' to fill the 'to' in current record when null, only do this when id is the same (id = previous(id)).

Could this help?

Dirk

Community Browser