Using alias columns to create measures

[#1]

Hi,

I did alias for the column names

like( POCKET_MARGIN as POCKET_MARGIN1)

and now i want to use to create a measure by using  pocket_margin1 like ( invoice_price1*pocket_margin1)

  i have stored the table in a qvd and loaded the data from qvd and from that columns i created the measure

but it is showing field not found error.

thanks in advance

[tamilarasu · Accepted solution]

Hi Srilatha,

Try this,

LOAD (INVOICE_PRICE2/SHIPPED_QUANTITY2) as price_contribution

FROM  'C:\pricing_profitability\Test.qvd' (qvd) ;

Or simply

LOAD (INVOICE_PRICE2/SHIPPED_QUANTITY2) as price_contribution

FROM  C:\pricing_profitability\Test.qvd (qvd) ;

[#3]

Thank you

It worked fine