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

[sunny_talwar]

Can you share the exact script you are using?

[#3]

i can't share the whole script but

POCKET_MARGIN ,

STANDARD_MARGIN,

STANDARD_MARGIN ,

POCKET_MARGIN,

SHIPPED_QUANTITY,

SHIPPED_QUANTITY,

INVOICE_PRICE ,

INVOICE_PRICE ,

STANDARD_COST ,

STANDARD_COST,

POCKET_MARGIN as POCKET_MARGIN1,

STANDARD_MARGIN as STANDARD_MARGIN1,

STANDARD_MARGIN as STANDARD_MARGIN2,

POCKET_MARGIN as POCKET_MARGIN2,

SHIPPED_QUANTITY as SHIPPED_QUANTITY1,

SHIPPED_QUANTITY as SHIPPED_QUANTITY2,

INVOICE_PRICE as INVOICE_PRICE1,

INVOICE_PRICE as INVOICE_PRICE2,

STANDARD_COST as STANDARD_COST1,

STANDARD_COST as STANDARD_COST2;

        SQL SELECT *

FROM PRICING."PRICING_PROFITABILITY" ;

Margin_walk:

load

POCKET_MARGIN1,

STANDARD_MARGIN1,

  STANDARD_MARGIN2,

  POCKET_MARGIN2,

  SHIPPED_QUANTITY1,

  SHIPPED_QUANTITY2,

  INVOICE_PRICE1,

INVOICE_PRICE2,

  STANDARD_COST1,

  STANDARD_COST2

  RESIDENT PRICING_PROFITABILITY;

  STORE [Margin_walk] INTO 'C:\pricing_profitability\Test.qvd' (qvd);

  Contribution:

  load

  [(INVOICE_PRICE2/SHIPPED_QUANTITY2)] as price_contribution

  from 'C:\pricing_profitability\Test.qvd';

[sunny_talwar]

Why are you adding square brackets here?

Contribution:

  load

  [(INVOICE_PRICE2/SHIPPED_QUANTITY2)] as price_contribution

  from 'C:\pricing_profitability\Test.qvd';

Try this may be:

Contribution:

LOAD (INVOICE_PRICE2/SHIPPED_QUANTITY2) as price_contribution

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

[#5]

thanks for the reply

I removed the square brackets and i reloaded it,but it is giving the same issue

[Anil_Babu_Samineni]

Can you check whether these values are stored in qvd/not. If so, Check in list box then tell me.

INVOICE_PRICE2 & SHIPPED_QUANTITY2

[sunny_talwar]

What is the exact error you are seeing?

[#8]

NO, the columns are not stored in QVD

can  you please suggest me the correct way to do it

[#9]

[Chanty4u]

Filed Names  and fieldValues are case sensitive.

Is checked or not?  in your actual data?