Qlik Community

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
jerryr125
Professor-Ambassador
Professor-Ambassador

Sorting on Data Load Editor - error

Hi - I am trying to sort a table in the data load editor

I authored the following:

 

TempTable:
LOAD BSTATUSDATA
*;
DataNew:
LOAD
*
RESIDENT TempTable
ORDER BY RPA,RPB,RPC;


DROP TABLE TempTable;

 

The original Table is BSTATUSDATA

 

Any thoughts ?

1 Solution

Accepted Solutions
Arthur_Fong
Partner
Partner

Try:

noconcatenate

DataNew:
LOAD
*
RESIDENT BSTATUSDATA
ORDER BY RPA,RPB,RPC;


DROP TABLE BSTATUSDATA;

View solution in original post

1 Reply
Arthur_Fong
Partner
Partner

Try:

noconcatenate

DataNew:
LOAD
*
RESIDENT BSTATUSDATA
ORDER BY RPA,RPB,RPC;


DROP TABLE BSTATUSDATA;

View solution in original post