Data loading from SQL - rows differ

krishnaroopa — Tue, 29 Jan 2019 06:54:21 GMT

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

Re: Data loading from SQL - rows differ

krishnaroopa — Tue, 29 Jan 2019 07:36:51 GMT

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