Re: Referencing new column

[davidcrossey]

Hi powerpeanuts,

You would need to add your new column first, before trying to use it in the where clause. For example:

q)t:([] name:`Dent`Beeblebrox`Prefect; iq:98 42 126) 
q)select name, iq2 from (update iq2:iq%100 from t) where iq2>1 
name    iq2 
------------ 
Prefect 1.26

Thanks for posting your question on the KX Community. Great username too!

Kind regards,

David