Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Hi,
Try the Order By the second table Resident.
By Rebeca
Hi Rebeca,
I tried the order by on the second table resident "Auftragspos2". This solves the problem - thanks
Bye
Mathias