topic Re: Automatic distinct load in QlikView

Automatic distinct load

Mon, 02 Dec 2013 06:27:30 GMT

Whenever i am downloading data from a table object to excel it is removing duplicate records. I need the number of records as it is available in source. My source file is excel. The count function is showing proper count of rows. But after extracting the data on excel only distinct records are appearing. Could any one help me to sort this issue???

Re: Automatic distinct load

sujeetsingh — Mon, 02 Dec 2013 06:35:45 GMT

I do not get it.

can you please explain .

Use non cancatenate load

Re: Automatic distinct load

Mon, 02 Dec 2013 06:40:11 GMT

Can you upload a sample app?

Re: Automatic distinct load

Mon, 02 Dec 2013 06:44:40 GMT

Hi Sujeet ,

Take data from Straight table to excel ..

hope it helps

Re: Automatic distinct load

Mon, 02 Dec 2013 08:30:34 GMT

I am loading data straight way from excel to qlikview. Once data loaded in qlikview i am storing it in table and exporting to excel again. After exporting data to excel the number of rows are not matching with original excel file.

Duplicate records are being get deleted automatically.. Hope i am clear this time....

Re: Automatic distinct load

Peter_Cammaert — Mon, 02 Dec 2013 08:42:40 GMT

You're not doing all of this in your load script, are you? Then the following may be helpful.

(In General: Don't do that. QlikView UI is not Excel)

I guess you're either using a Table Box or a Straight Table in the UI to bring the data from QV back into Excel.

A table box only shows distinct sets of value combinations. Duplicates are dropped. All columns are treated as list boxes, which omit duplicates by nature.
A straight table probably has some expression column somewhere, forcing it to aggregate data and merging duplicate dimension sets. Even when every amount is displayed as a dimension, you can't be sure that there won't ever be rows with identical dimension values and identical amounts.

You could add a RowNo() column to your table in your load script and to the object-to-export on your sheet. That will force QlikView to treat every row from its internal table as unique. After the export to Excel, omit the RowNo() column.

Best,

Peter

Re: Automatic distinct load

jagan — Mon, 02 Dec 2013 09:40:42 GMT

Hi Shailesh,

I think you have exported to excel from Table box, as it will remove duplicates. What you can do is while loading data from excel arrive one more column RowNo which is a key field to identify each row and add this column to the Table and then export. Now none of the rows will miss.

Try this script

Data:

LOAD

RowNo() AS RowNumber,

FROM FileName;

Regards,

Jagan.

Re: Automatic distinct load

Mon, 02 Dec 2013 11:27:38 GMT

Thanks a lot..

Regards,

Shailesh

Re: Automatic distinct load

Peter_Cammaert — Fri, 06 Dec 2013 09:02:10 GMT

Please close the dicussion by marking a reply as an Answer. That makes it easier for us to track unanswered questions. Thanks.

Peter