Query items defined in the derivation of the source file

shivan · Post by **shivan** » Tue Aug 02, 2005 11:55 am

hi,
i have a sql query which i defined in the source file and i am taking the data through that query. Where as i also defined the column names in the column section of the source file. Beside the column name there is a derivation column. I am just confused what i have to write there. For eg: there is a calculated column in the query like sum(z*b) as test, so do i have to define the same formula in the derivation like sum(z*b) and column name test.
thanks
shivan

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Aug 02, 2005 12:00 pm

shivan · Post by **shivan** » Tue Aug 02, 2005 12:15 pm

so can i leave it blank. What its purpose then.

thanks
shivan

Sainath.Srinivasan wrote:No