Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please ignore this question. Found the Issue. In the load, using subField, splitting a column so the rows are duplicated