First off we can't filter out all rows based on the selection. We need to keep the actual row of data but in some way flag that particular value as a null when it comes to the calculation within one of the eda plugins.
So lets say you have the following dataset and you want to define 99 as unknown in the sex column.
sex age
1 32
2 66
1 22
99 15
The calculation of the the average within the sex colum would be
(1+2+1)/3 = 1.33
The calculation of the the average within the age would be
(32+66+22+15)/4=123.75
Second thing the line of ecl code you have does
cancerDS_Filtered:=cancerDS((sex BETWEEN 99 AND 99));
which would give me only rows with values of 99.
Third thing
should have a read only field on the General tab that is populated with the resulting filtered dataset.
Fourth thing
The column information isn't propagated to the next plugin so you can't select your fields.
Doesn't seem to work right.
First off we can't filter out all rows based on the selection. We need to keep the actual row of data but in some way flag that particular value as a null when it comes to the calculation within one of the eda plugins.
So lets say you have the following dataset and you want to define 99 as unknown in the sex column.
sex age 1 32 2 66 1 22 99 15
The calculation of the the average within the sex colum would be (1+2+1)/3 = 1.33 The calculation of the the average within the age would be (32+66+22+15)/4=123.75
Second thing the line of ecl code you have does cancerDS_Filtered:=cancerDS((sex BETWEEN 99 AND 99));
which would give me only rows with values of 99.
Third thing should have a read only field on the General tab that is populated with the resulting filtered dataset.
Fourth thing The column information isn't propagated to the next plugin so you can't select your fields.