Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You could try
if(len([MyField])=0, 'yes', 'no')
or
if(isnull([MyField)], 'yes', 'no')