Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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???
I do not get it.
can you please explain .
Use non cancatenate load
Can you upload a sample app?
Hi Sujeet ,
Take data from Straight table to excel ..
hope it helps
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....
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.
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
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.
Thanks a lot..
Regards,
Shailesh
Please close the dicussion by marking a reply as an Answer. That makes it easier for us to track unanswered questions. Thanks.
Peter