Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
ID | Value |
---|---|
1 | 1 |
2 | 2 |
3 | 0 |
4 | 0 |
5 | 10 |
6 | 0 |
7 | 20 |
In the above table, I would like to fill the zero in LOAD Script. How can I make the table become Table B? Thanks
Table B
ID | Value |
---|---|
1 | 1 |
2 | 2 |
3 | 2 |
4 | 2 |
5 | 10 |
6 | 10 |
7 | 20 |
try
Like this:
LOAD
ID,
If(Value=0,Peek(Value),Value) as Value
FROM
...sourcetable...
;
try