Set Analysis or script

[Surya]

Hello All,

Here I Have Scenario

I Have Data Like 

Branch    ID  Fee

CSE , 120 ,  2000

CSE , 122 ,  2001

IT , 130 , 1800

IT, 133 , 1800

 Here i want branch wise different fees information only not required same fee entire data

Expected Output

Branch    ID  Fee

CSE , 120 ,  2000

CSE , 122 ,  2001

[lironbaram]

hi 

this should work for you in a table 

if(count(distinct total <Branch> Fee)>1,Fee,0)

[tresesco · Accepted solution]

Script:

t1:

Load * From <>;

Right Join

Load Fee where Count=1;

Load Count(Fee) as Count, Fee Resident t1 Group By Fee;

Chart:

Dim 1: Branch

Dim 2: ID

Exp : Only( {<Fee={"=Count(Fee)=1"}>} Fee) 

[Brett_Bleess]

You have received two replies to your use case question, we would appreciate if you could close out the thread by using the Accept as Solution button on the response(s) that helped.  This gives the poster(s) credit for the assistance and lets other Members know what worked for you.  If you have further questions, please leave an update post.

Regards,
Brett

[Saravanan_Desingh]

One solution is.

tab1:
LOAD * INLINE [
    Branch, ID, Fee
    CSE, 120, 2000
    CSE, 122, 2001
    IT, 130, 1800
    IT, 133, 1800
];

Left Join(tab1)
LOAD Branch, Count(Fee) As C1_Fee, Count(DISTINCT Fee) As C2_Fee
Resident tab1
Group By Branch
;

tab2:
LOAD Branch, ID, Fee
Resident tab1
Where C1_Fee=C2_Fee
;

Drop Table tab1;

[Saravanan_Desingh]