topic export ALL rows from a table with dups in QlikView

export ALL rows from a table with dups

Sat, 24 Sep 2011 17:23:41 GMT

Hi all,

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.

Roland

export ALL rows from a table with dups

swuehl — Sat, 24 Sep 2011 17:39:22 GMT

Hi Roland,

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).

Regards,

Stefan

export ALL rows from a table with dups

Sun, 25 Sep 2011 15:07:17 GMT

Hello Stefan,

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

LOAD

...

While IterNo( ) <= Anz;

with Anz being my count().

So long

Roland

export ALL rows from a table with dups

Oleg_Troyansky — Sun, 25 Sep 2011 15:13:19 GMT

Roland,

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:

BINARY <MyOldDocument.qvw>

store Table1 into Table1.qvd;

store Table2 into Table2.txt (txt);

This should work...

cheers,

Oleg

export ALL rows from a table with dups

Mon, 26 Sep 2011 08:01:00 GMT

Hi Oleg,

Thats it ! Live can be so easy.

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.

Many Thanks

See you

Roland