Problem with IF statement in Load

[Black_Hole]

Hello all,

In my script, I write an IF statement and I save the result in a new column.

But I don't understand why after to run the script I get none value for the column created.

• Below my script:

AMOUNT:
LOAD *,
IF(LEN(Type)=0,Credit,Debit) as test
RESIDENT JOURNAL;

• Below the result:

Please could you help me to resolve this problem.

Thank you in advance for your help.

[neelamsaroha157]

Can you add a new column as  LEN(Type) just to check the values you for the newly added column.

[Brett_Bleess]

Only other thing that came to mind for me was if you aliased Type in the original load statement and are using the original field name not the alias?  Highly unlikely, but I wanted to toss it out there just in case.

Regards,
Brett

[nicolas66]

Bonjour,

If(LEN('Type')=0, 'Credit', 'Debit') as test 

... perhaps ?

[Berndtssono]

if(len(Type)='0', Credit, Debit) as test

maybe like that