Update value for Blank cells

[Anonymous]

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

[Anonymous]

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.

[beck_bakytbek]

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

[Anonymous]

I am getting above table result after did some joins There is any other way to do that

[Anonymous]

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.

[vishsaggi]

Can you show us those Join script you have that is populating this result table?

[johnca]

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