autofill empty field

[#1]

Hi all,

i got a problem.

I got a filed with 3 values:

- A

- B

- empty

I need to replace the empty fields with "C", i'm trying to build a new field using if functions without success, any suggestion?

Thanks

[MayilVahanan]

Hi

     Try like this,

     Load *, if(Len(Trim(Field)) > 0, FieldName, 'C') as fieldname from tablename;

     Hope it helps

[#3]

but in the new field i should also keep A and B

[MayilVahanan]

Hi

     Len(Trim(FieldName)) gives the length of the field value, if is less than 1 means, it replace the empty string with 'C' otherwise it keeps the original value. so, A and B also there .

     If(Len(Trim(FieldName)) >0 , FieldName, 'C') gives A,B and C

Hope it helps

[#5]

is not working...maybe the syntax is incorrect

[CELAMBARASAN]

Can you post the syntax you used?

[MayilVahanan]

Hi

     Check the attached file..

[#8]

if(Len(Trim([Tipo ])) > 0, [Tipo],'C') as "AA"

In the new columns it gives me the correct field (a & b), but still left empty the empty ones

[#9]

I also tried with

if([Tipo]='A','A', if([Tipo]='B','B','C')) as "AAA"

and

If (IsNull([Tipo]),'C', [Tipo]) as "BBB"

but is still have no C

It seems like the fields are not empty, consider that they are populated as calculation of other fields

[#10]

This is a formatting problem

You need to format you inline as txt

Load

*
,if(Len(Trim(Testing))<>0, Testing, 'C') as Test Inline
[
Testing,Value
A,1
B,2
,3
D,4
](TXT);