Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

mschreiber
New Contributor III

STORE INTO on a sorted resident table exports unsorted

Hello,

for data conversion I have to export data sorted to a txt-file.

Auftragspos:
LOAD
  Angebotsnr,
  POSITIONSNR as Position,
RESIDENT Auftragspos_tmp ORDER BY Angebotsnr,POSITIONSNR;


Auftragspos2:
NOCONCATENATE LOAD
    Angebotsnr,
    Position,
RESIDENT Auftragspos;

STORE Angebotsnr,Position FROM Auftragspos2 INTO $(varOutputPath)Auftragspos.txt (ansi, delimiter is '|');

DROP TABLE Auftragspos

The table viewer show sorted table Auftragspos2 correctly.

Then I stored this internal table into an external text-file "Auftragspos.txt". When I opening the text-file the lines are not sorted.

Anyone an idea how I can force a sorted export ?

1 Solution

Accepted Solutions
Not applicable

Re: STORE INTO on a sorted resident table exports unsorted

Hi,

Try the Order By the second table Resident.

By Rebeca

2 Replies
Not applicable

Re: STORE INTO on a sorted resident table exports unsorted

Hi,

Try the Order By the second table Resident.

By Rebeca

mschreiber
New Contributor III

Re: STORE INTO on a sorted resident table exports unsorted

Hi Rebeca,

I tried the order by on the second table resident "Auftragspos2". This solves the problem - thanks

Bye

Mathias

Community Browser