How to check if count of distinct values >1 in Data Load Editor

[mahishah]

Hello, I am trying to load a resident table in qlik sense data load editor 
How do I check if count of distinct values is more than one in a group by. 

For example, by doing group by in col A i want to see how many distinct entries are there in col B 

[Or]

Load A, Count(Distinct B) as C

From SourceTable

Group By A;

[mahishah]

I am using a resident table not a source connection. 

Count(Distinct B) is throwing a syntax error 

thanks 

[sandeep-singh]

Hi @mahishah, the code shared by @Or is completely correct. If you don't want to use SourceTable then you change the path to use resident table. 

Sample code and output for your reference.

Abc:
Load * inline [
A,B
3456,TRUE
4567,FALSE
2905,TRUE
2905,FALSE
9856,FALSE
1298,TRUE
5674,FALSE
5674,FALSE

];

Output:
Load A, Count(DISTINCT B) as C
Resident Abc
Group By A;

drop table Abc;