topic Fill empty values with last not null values in QlikView

Fill empty values with last not null values

Wed, 12 Apr 2017 19:33:12 GMT

Hi,

I need to resolve this issue in load script.

For every ID and Task I have WorkFlow Id (min Start Date), but I need the same Workflow Id for all next empty values.

I have tried Previous and Peek function but without success.

Any help?

Thanks.

Anil_Babu_Samineni — Thu, 13 Apr 2017 01:27:38 GMT

Can you share sample instead of image. Or look at here Get previous row value when the value is null

jonathandienst — Thu, 13 Apr 2017 05:24:49 GMT

Something like:

LOAD

ID,

Task,

[Start Date],

[End Date],

If(Len([Workflow Id]) = 0, Peek([Workflow Id]), [Workflow Id]) as [Workflow Id]

FROM ....

Have not tested this as you pasted your sample data as an image.

Kushal_Chawda — Thu, 13 Apr 2017 06:52:16 GMT

try this

Data:

LOAD

ID,

Task,

[Start Date],

[End Date],

[Workflow Id]

FROM Source;

Final:

noconcatenate

LOAD *,

if(len(trim([Workflow Id]))=0,peek([Workflow ID]),[Workflow Id]) as [Workflow ID]

Resident Data

order by ID,Task,[Start Date];

drop table Data;