I wonder how to export all rows of a QV-Table. This table has duplicate rows and I want to export all of them, the whole table as it is. Export-files that I produced via Tablebox or Straighttable have only unique rows. Any Ideas ?
I Can't (re)load because I do not have access to the org. sources.
if you lost access to the original data sources, but you have access to the QVW, you can load it into a new QVW using binary load, and then store all the tables into either QVD or text files. In essense, you can recreate all your original data sources (well, almost - they will be transformed) in the new QVD structure:
maybe you could use a straight table with all fields of your table to export as dimensions, add a =count(LASTDIMENSION) as expression, which should give you the count of duplicates per line.
You could then export this table to excel and read it back in to QV, this time using while to create extra lines for the duplicate. Then store table to csv.
All in all a two step process, I don't know of anything shorter if you can't reload from original source and add something like a uniqe recno to the table (which I assume you don't have).
yes, it seems to be the only workaround. I hoped to get another answer sth like a simple table export. Well, that's what I am missing but I reloaded the excel-export using a
if you lost access to the original data sources, but you have access to the QVW, you can load it into a new QVW using binary load, and then store all the tables into either QVD or text files. In essense, you can recreate all your original data sources (well, almost - they will be transformed) in the new QVD structure:
Sometimes I am working offline and need to rebuild the data-modell, eg. new fields etc. And then it is usefull to load again. 😉 Without having access to the org. datasources. Back in the office I proof of course my new app with the org data.
