Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
maxgro
MVP
MVP

please could you explain the rule to identify nulls?

or mark the records you want to load?

Not applicable
Author

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
Creator III
Creator III

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