topic Update statement in qlikview in QlikView

Update statement in qlikview

Thu, 05 Jan 2017 14:34:25 GMT

Hi,

Please suggest me, how can I use update command in qlikview

Below is my data

T1:
Load * inline
[A, B, C, D
1, a, b, src1
1,,,src2
2, x, y, src1
2,,,src2];

I want to update null vaues ( in script) then o/p should be

[A, B, C,D
1, a, b,src1
1,a,b,src2
2, x, y,src1
2,x,y,src2];

sunny_talwar — Thu, 05 Jan 2017 14:43:48 GMT

Try this:

T1:

Load * inline

[A, B, C, D

1, a, b, src1

1,,,src2

2, x, y, src1

2,,,src2];

FinalTable:

NoConcatenate

LOAD A,

If(Len(Trim(B)) = 0, Peek(B), B) as B,

If(Len(Trim(C)) = 0, Peek(C), C) as C,

Resident T1

Order By A, D;

DROP Table T1;

Thu, 05 Jan 2017 16:53:13 GMT

Hi Sunny,

Many Thanks for your help. It's working.

sunny_talwar — Thu, 05 Jan 2017 22:10:53 GMT

Please close the thread by marking the correct response.

Best,

Sunny