topic Re: Re: Add value from the first raw to all raws in QlikView

Add value from the first raw to all raws

alec1982 — Mon, 18 Nov 2013 20:13:13 GMT

Hi guys,

I have a table as follow

ID Value

1 100

2 -

3 -

How can i create a new field to have the same value(100) for all IDs and my table will look like

ID Value New value

1 100 100

2 - 100

3 - 100

Thxs,

Alec

Re: Add value from the first raw to all raws

MayilVahanan — Mon, 18 Nov 2013 20:17:07 GMT

try like this

Load ID, Value, If(Isnull(Value),Peek('NewValue'), Value) AS NewValue From tablename;

Edit:

Load ID, Value, If(Len(Trim(Value))=0,Peek('NewValue'), Value) AS NewValue;

Load * Inline

[

ID , Value

1, 100

];

Re: Add value from the first raw to all raws

alec1982 — Mon, 18 Nov 2013 20:36:12 GMT

hi,

It is not working.. I am getting an error..

Syntax error, missing/misplaced ..

Re: Re: Add value from the first raw to all raws

MayilVahanan — Mon, 18 Nov 2013 21:15:41 GMT

Its working for me.. Check file

Re: Add value from the first raw to all raws

albertovarela — Mon, 18 Nov 2013 22:00:43 GMT

Hello, For this specific case try:

DataTemp:

LOAD * INLINE [

ID, Value

1, 100

2, -

3, -

];

Data:

LOAD

,Value

,if(RowNo()=1 ,Value,peek(Value,0)) as NewValue

Resident DataTemp

;

Drop Table DataTemp

;