Fill previous value where there is blank

[gauravgg]

Hi All

I have the following table

Currency	Date	Value
USD	01/01/2017	56
USD	02/01/2017
AED	01/01/2017	18
AED	02/01/2017
AED	03/01/2017
AED	04/01/2017

I want the following output

Currency	Date	Value
USD	01/01/2017	56
USD	02/01/2017	56
AED	01/01/2017	18
AED	02/01/2017	18
AED	03/01/2017	18
AED	04/01/2017	18

ie where ever there is null value in the Value field ,i want to put previous value in that field

can anyone help me

Thanks in advance

[tresesco]

Try like:

Load

          Currency,

          Date,

          If(Len(Trim(Value))=0, peek(Value), Value) as Value

From <>:

Note: Your loading sort order might have to be defined using Order By clause;.

[gauravgg]

Hi Thanks for reply

But it is not working.

is there any other way ?

[tresesco]

Could post a qvw with sample data set showing that is not working?

[Anonymous]

Try like:

Load

          Currency,

          Date,

          If(Len(Trim(Value))=0, peek(Value), Value) as Value

From <>:

Note: Your loading sort order might have to be defined using Order By clause;

try with peek('Value') instead

[tresesco]

It works even without quotes.

[Anonymous]

that's new for me... but ok

[ahmar811]

Hi

Gaurav

Please find the attached file for your output

Regards

Ahmar