Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
here in Class() what is[value] ??? and why we are using 10??
plese give me the answer.....
those data should be coming in between <= and < (or) >= and < like that.
what is the main theme of class() function??
please tell me.....
class function is used for classification of expression
class(value,10) syntax returns like this value<=x<10 here 10 is the interval
in your scenario first value is 10
then 10<=x<10
next 11 gives like 1<=x<10 , 11<=x<20 your value between 11 its in between of 11<=x<20
like this all ....
i hope u understood
class function is used for classification of expression
class(value,10) syntax returns like this value<=x<10 here 10 is the interval
in your scenario first value is 10
then 10<=x<10
next 11 gives like 1<=x<10 , 11<=x<20 your value between 11 its in between of 11<=x<20
like this all ....
i hope u understood
hello,
I have another doubt.not class().
i.e we have 2 txt files .one file date in MM/DD/YYYY format.
another txt file date in YYYY/MM/DD format.
combining these 2 txt files. we will get the date format as DD/MM/YYYY.by using Date# function.
How to get it in DD/MM/YYYY format?? by using "Date#".
please send me answer..............
Hi,
Class function will divide the values as you gave here 10
here it will divide like
1>=x<10
11>=x<20
21>=x<30
31>=x<40
41>=x<50
in 1 field only.this is just like a bucket field.
and your second scenario
Date(date#(datefield,'DD/MM/YYYY'),'DD/MM/YYYY') as New_Date
try this it works ,
date(date#(yourdatefield,'mm/dd/yyyy'),dd/mm/yyyy)
vishnu priya pls close this thread and raise a new question
endhukante ila raise chesthe we may forget to see ur question.
how to close thread??
that date function is not working....
please help me for this.....
click on ur question (open your inbox>right click on your question>open in new tab > u will get options liek correct and helpful answers
try with out comma
date(date#(yourdatefield,'mm/dd/yyyy')dd/mm/yyyy)
if not worked pls post some sample data
this date function not working.
please give me another scenario....