Set analysis

[maniram23]

Hi Experts,

I trying  but i am not getting exact output in set analysis,

These are my condition. i wrote in based on if conditions but i need in set analysis.

In my data i have null values.

=COUNT(IF(LEN(PLAYER)>0 AND LEN(SKILLS)>0,SN))

=COUNT(IF(LEN(PLAYER)>0 OR LEN(SKILLS)>0,SN))

for example

LOAD * INLINE [

SN,PLAYER, SKILLS

1, DHONI, KEEPING

2, DHONI, BATTING

3, KOHLI, BATTING

4, KOHLI, FEALDING

5,      , BATTING

6, RAHUL,       

];

regards,

[vinieme12]

Count ({<SN={"=len (player)>0 or len (skill)>0"} >} SN)

[maniram23]

Hi Vineeth,

thanks for your replay,

But i am not getting.

please post your Exercise qvw.

regards,

[maxgro · Accepted solution]

Count ({<SN={"=len (trim(PLAYER))>0 or len (trim(SKILLS))>0"} >} SN)

[vinieme12]

You have spaces in your sample , either purgechar the space or trim it as Massimo has shown below

Or try it using an excel load which does not have space or enter characters