If loop in Tabelle

[Anonymous]

Hello everyone 

I want to write an if loop in the script:

if there is no value in the second column "age" of the table below, the fifth column must be empty or #NULL! stay.

 

if (age=0 , DRG=#NULL!)

I'm not so sure if this previous condition is enough.

I would be grateful for any answer 🙂

[MendyS]

Hi @Anonymous 

try to do that in the data load editor, 
TeableName:

No Concatenate

Load *, if ( age>=0, fifthColumnName) As fifthColumnNameTemp

Resident ...

Drop Field fifthColumnName;

Rename fifthColumnNameTemp to fifthColumnName;

[Anonymous]

Thanks for the answer

I didn't mention that the screenshot is a script.

The goal is:
There is no need to write a value in DRG if there is no age.

It is not exactly about renaming, but about change the value in #NULL!.

[MendyS]

@Anonymous 

yes, I know.

what I write gives you null if there is no value in the age field (if the age is small from 0, the field returns Null).