Im new in QV
i have 2 fields like this.
load * inline [type, weightnormal, 0.2express, 0.8saver, 2.4express, 1.1normal, 0.7....];
is it possible to use ceil() each types?
I hope is this what do you want.
load * inline [
type as Type
,ceil(weight) as Weight
drop table OriginalTable;
Yes, it is possible to use ceil().
Take resident of our inline table
ceil(weight) as weight
Drop table inline_table;
Hope you get it.
No, no you guys get it wrong.
I need ceil it different for each types.like normal weights ceil(weight), and express(weigh, 0.5) etc.
if you have 3 or 4 attributes in type field, try to use
if condition as
if(type='express', ceil(weight, 0.5),
))) as new_weight,
hope this help you.
Thanks & Regards,
Can i ask you 1 more thing again?how about this one
express, 0.5express, 1express, 1.5......express, 10express, 11express,12so on.i need to ceil 0.5 in under 10 and ceil 1 in after 10.
use the clause WHERE weight<=10 when you create your new table and make other WHERE for weight>10.
I wanna end it today. Please someone help me : [
Retrieving data ...