Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have table as below and would like update blank cells in B to 0 (zero) for row 2,5,6.
TabA:
A | B |
1 | 100 |
2 | |
3 | 300 |
4 | 400 |
5 | |
6 | |
7 | 700 |
But i know the below script to replace value. is there any other ways to replace value for table without full resident load again especially with joins or something in script
TabB:
A,
If(len(B)=0,0,B) as B
resident TabA;
regards
Ramu
Hi
Why not do your check If(len(B)=0,0,B) as B in the initial load then you won't need to do a resident load.
Hi Ramu,
you can use in this case: IsNull-Function or as @Brian Copple said, you can use if(len(B)=0,0,B) without resident load
I am getting above table result after did some joins There is any other way to do that
Hi Ramu
It may help if you can share your app or some more info to your requirements. Are you joining columns A & B in your example from different tables? If so you should still be able to test for blanks in your column B in the initial load. Maybe I'm not understanding your problem correctly.
Can you show us those Join script you have that is populating this result table?
Hi Ramu,
In a table box that isn't possible, but in a straight table it is. You need a way to write the expression and table box doesn't include that. In a straight table use A as dimension and then your expression as expression. On Presentation tab uncheck Suppress Zero-Values.
HTH,
John