var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: updating the table
I wanted to update my table. If my new column is derived based on the existing column, how do I go about that. For example, if column H has different numbers.
I want to set 0-5 from column h and make it as values "12a-6a" in column D.
6-10 from column h and make it something else in column D.
Please let me know if anyone knows. Thanks.
please show your current table layout
we could guess what you're trying to do, but that would waste our time and yours
Columns: Realtime, hour and Part
Part is an empty column, it's values are derived from hour.
For example the hour column has numbers like 0,1,2,3,5,6,7,8,9,11,12...etc
The Part column wants to show that for hours 0 to 5, it is equal to "12a-6a" , for hourd 6 to 10 it is equal to "something else"
Set Daypart= '12a-6a' if HOUR >='0' and Hour <='5'
'6a-12p' if hour>='6' and hour <='11'
'12p-6p' if hour>='12' and hour<='15'
'6p-12a' if hour>='16' and hour <='23'
This is the idea, but I dunno how to incorporate that into the update statement syntax.
I figured it out, thank you
Originally Posted by Mangolili
others with similar problems, when they search the site, will find this thread, so it's only fair that you post your solution
This is my solution and it works
Set Part= '12a-6a' where HOUR >='0' and Hour <='5'