Can I have a temp column with "Y" or "N" result?
I have a column name
LastKnownWellDate which stores dates. I need to have "Y" in a new temp column if date is entered. If date not entered then "N" in temp column.
If LastKnownWellDate is null then "N" in TempColumnLastKnownWell Else "Y" in TempColumnLastKnownWell
TempColumnLastKnownWell needs to be a temporary column. It currently does not exist and I don't want it permanently.