How can I export all my rows to Excel ?

[#1]

Hi,

I have loaded a table of 90 rows into QV. There are duplicate rows in this data set.

However, when I export the records to Excel, it ignores the duplicates and doesn't export them to the spreadsheet.

How can I get round this problem and ensure that ALL records (duplicates or otherwise) are copied over to the spreadsheet ?

Thanks

MV

[Gysbert_Wassenaar · Accepted solution]

Add a rownumber field in the script and add that new field to the table box object you want to export too. Otherwise Qlikview will simply export what's shown in the table box object.

LOAD *, rowno() as RowNumber

from ...somewhere...;

[ramasaisaksoft]

Hi Maureen,

     I also suggested Wassenaar advice.

Because when u add one more column in that tables it shows (rowno() function )shows number of records in that table,So when u export u r Table to Excel it shows all values and data .

[#4]

That's great and a good way of displaying EVERY record in a datafile.

Many thanks.