how to use if then else statement to create new column?

[#1]

Hi, how should the script be like if I want a column 'before 10am' to be 1 if the column 'time' is >=10:00:00, else it will be 0? Thanks.

[marcus_malinow]

Hi Rachel,

you could use this expression:

if(hour([timefield]) < 10, 1, 0) as [before 10 am]

Marcus

[anbu1984]

Why did you start duplicate thead?

Original thread: How to use if then statement to create new column

[manideep78]

Try this in the script

If(Your_Column_Name<10:00:00 ,1, 0) as New_Column

Make sure you give the Appropriate date format in the condition above,

Hope this helps you.

Regards,

Manideep.

[#5]

Thanks, but apparently I cant put comma no matter what I do...

[manideep78]

Please check whether the date format is appropriate or not.

if you are writing if condition in preceding load make sure you put semicolon at the end.

Eg:

Load *, if(condition) as New_Column;

Load

A,

B,

C

From <Path>

Or else post your script in which you need the condition.

[lukaspuschner]

i think this will work:

if(Time(YourField)<MakeTime(10),1,0)

[#8]

This is my script:

LOAD * INLINE [

    Before 10am,

];

if([Time])<10:00:00,1,0) as [Before 10am];

The underlined colon after '10' has error. Thanks.

[#9]

Hey thanks for your answer, but the comma after (10) has error.

[manideep78]

Try this

LOAD *, if(Hour(Timestamp(Time,'hh:mm:ss'))<10,1,0) as before10am;

LOAD * Inline [

Time

10:00:00,

11:00:00,

9:00:00

];

This should work