Trying to add values to Null

[nickmarlborough]

Hi, 

I have many cases in my data where the question asked essentially is: 

if value () doesnt appear // does appear in this table then 'Yes' else 'No'

this simple formula is proving very challenging to do without creating synthetic keys. 

Is there an easy one line formula you are able to slot into the actual table in the load editor that would solve this. For example:

Load

*,

If......'yes','no

from File

Please help 

[henrikalmen]

You could try
    if(len([MyField])=0, 'yes', 'no')
or
   if(isnull([MyField)], 'yes', 'no')