Creating a feild in a script.

[#1]

I have two fields that I would like to use to create a new field ( simply one field minus the other). I need to create this field to use it in set analysis. I have attemped to use the formula below in my script with now luck

Set New Field = Field1-Feild2;

Any suggestions?

Thank you!

[#2 · Accepted solution]

How about adding it to your load script?

i.e.

LOAD *, Field1-Field2 as "New Field";

[Anonymous]

Hi jhoffman ,

I'm not sure if I understood you well, but you could try to use the LET statement instead of SET.

So,

LET Field = Field1-Feild2;

would result in a difference between the two fields.

I guess this is what you are looking for.

Valera 🙂

[#4]

Thanks for the help!! I should have been more clear with my issue , but adding my new field to the load script allowed me to use it in set analysis.

Thanks again,

Jeff