Count expression in edit script generating an error

[#1]

HI all,

When i am writting an Count expression in edit script , then it is generating an error with out any message just displaying the table.

Below line i am using , is there any mistake in this ?

if(DefectName ='Defect.EdgeChip',if(Count(DefectStatus='Fail')>0,2,1),'Null') as [Status EdgeChips]

Thanks in advance

Regards

Venkat

[kaushiknsolanki]

Hi,

    Count is a aggrigation function, so if you want to use it in script, you need to specify the group by function.

Regards,

Kaushik Solanki

[its_anandrjs]

Hi,

As i understand your code that is to be written some thing like this will work better please check it

if(DefectName ='Defect.EdgeChip',if(DefectStatus='Fail',Count(DefectStatus)>0,2,1),'Null') as [Status EdgeChips]

Regards

Anand

[its_anandrjs]

Hi,

Yes Count is aggregation function as kaushik says you need to aggregate your code try this code

Count(if(DefectName ='Defect.EdgeChip',Count(if(DefectStatus='Fail' and Count(if(DefectStatus)>0,2,1))))) as [Status EdgeChips]

And let me know

Regards

Anand

[#5]

Hi Kaushik,

My Task requirement is " if any one Fail is having in an LensKey then the Status should be 'FAIL' or 'Pass' "   and also see the attached script document.

The below is the sample example.

Ex1

LensKey, DefectStatus

1, Fail

1,Pass

1,-

For this ex1 , the result should be = Fail

Ex2:

LensKey, DefectStatus

2, Pass

2,Pass

2,-

For this ex2 , the result should be = Pass

Ex3

LensKey, DefectStatus

3,Fail

3,Fail

3,Fail

For this ex3 , the result should be = Fail

Ex4

LensKey, DefectStatus

4,-

4,-

4,-

For this ex4 , the result should be = NotAvailable.

Thanks in advance

Regards

Venkat

[#6]

Hi anandrjs,

My Task requirement is " if any one Fail is having in an LensKey then the Status should be 'FAIL' or 'Pass' "   and also see the attached script document.

I Used below line in edit script, it is not getting the correct result . Can you suggest the correct solution to get this.

if(sum([Status EdgeChips1])>=3,'Fail',if(sum([Status EdgeChips1])>=1,'Pass','NA')) as [Status EdgeChips]

The below is the sample example.

Ex1

LensKey, DefectStatus

1, Fail

1,Pass

1,-

For this ex1 , the result should be = Fail

Ex2:

LensKey, DefectStatus

2, Pass

2,Pass

2,-

For this ex2 , the result should be = Pass

Ex3

LensKey, DefectStatus

3,Fail

3,Fail

3,Fail

For this ex3 , the result should be = Fail

Ex4

LensKey, DefectStatus

4,-

4,-

4,-

For this ex4 , the result should be = NotAvailable.

Thanks in advance

Regards

Venkat

[kaushiknsolanki]

Hi,

    I havent tried this as i am not using my laptop now, but you can give a try.

Data:
Load * inline [
Student , Status
1, Fail
1, Pass
1, NA
2, Fail
2, Fail
2, Fail
3, Pass
3, Pass
3, Pass
4, NA
4, NA
4, NA
];

Data1:
load
student,
count(if(status = 'Fail'),status) as status_F_count
count(if(status = 'Pass'),status) as status_P_count,
count(if(status = 'NA'),status) as status_NA_count,
resident Data;

Data2:
Load
Student,
if(status_f_count >= 1,'Fail',
   if(Status_P_Count >=1, 'Pass','NA')) as Final_Status
Resident Data1;

Drop table Data1;

Regards,

Kaushik Solanki

[#8]

Hi Kaushik,

When i am using your code in edit script it show an syntax error line in below lines

count(if(status = 'Fail'),status) as status_F_count

count(if(status = 'Pass'),status) as status_P_count,

count(if(status = 'NA'),status) as status_NA_count,

resident Data;

Regards

Venkat

[its_anandrjs]

Hi,

Now check this you left some commas on that.

Data1:
load
student,
count(if(status = 'Fail'),status) as status_F_count,
count(if(status = 'Pass'),status) as status_P_count,
count(if(status = 'NA'),status) as status_NA_count
resident Data;

Data2:
Load
Student,
if(status_f_count >= 1,'Fail',
   if(Status_P_Count >=1, 'Pass','NA')) as Final_Status
Resident Data1;

Drop table Data1;

Regards,

Anand

[kaushiknsolanki]

Hi,

    Yes i am sorry actually we need so use the group by function.

    Try this.

Data:
Load * inline [
Student , Status
1, Fail
1, Pass
1, NA
2, Fail
2, Fail
2, Fail
3, Pass
3, Pass
3, Pass
4, NA
4, NA
4, NA
];

Data1:
load
student,
count(if(status = 'Fail'),status) as status_F_count
count(if(status = 'Pass'),status) as status_P_count,
count(if(status = 'NA'),status) as status_NA_count,
resident Data group by student;

drop table Data;

Data2:
Load
Student,
if(status_F_count >= 1,'Fail',
   if(Status_P_Count >=1, 'Pass','NA')) as Final_Status
Resident Data1;

Drop table Data1;

EDIT:- Have a look at the attached document.

Regards,

Kaushik Solanki