Update statement in qlikview

[#1]

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 · Accepted solution]

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,

  D

Resident T1

Order By A, D;

DROP Table T1;

[#3]

Hi Sunny,

Many Thanks for your help. It's working.

[sunny_talwar]

Please close the thread by marking the correct response.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny