calculation in inline is it allowed

[#1]

when i scripted as follows i cud not get data for cost/10...y it is so?

load * Inline [ id,cost,(cost/10)

101,500

102,790

103,900

];

[#2]

You can try doing it after the Inline using Resident of that Table and then Droping it.

[anbu1984]

Load id,cost,(cost/10) Inline [

101,500

102,790

103,900

];

[senpradip007 · Accepted solution]

Try like

load id,cost,(cost/10) As NewCost Inline [

id,cost

101,500

102,790

103,900

];

[#5]

which table 2 drop n y 2 drop it?

[#6]

it gives error dude s it cant find the field names u specified...

field names r needed prior 2 data

[#7]

This is what I meant

Table_Temp:

load * Inline [ id,cost

101,500

102,790

103,900

];

Table:

Load

id,

cost,

(cost/10)

Resident Table_Temp;

Drop Table Table_Temp;