Data loading from SQL - rows differ

[krishnaroopa]

Hi all

I have a query in SQL, that has group  by Clause, like "Select Dept, count(Studentid) from tbl_Students group by Dept" 

Now i get result like "CSE 5" in SQL Server. 

When i load the data in Qlikview server, I get 5 duplicate rows "CSE 5" 

So strange !!

I tried to put the output to a temp table and select only from that, still duplicate rows!!

Has anyone come across such issue?

Thanks

KRS

[krishnaroopa]

Please ignore this question. Found the Issue. In the load, using subField, splitting a column so the rows are duplicated