topic Re: Quick ways to load into a resident table in QlikView

Quick ways to load into a resident table

tinkerz1 — Thu, 02 Jul 2015 15:22:32 GMT

Can you wildcard from a load table like the below script and it will use the aliases?

tab1:

Select * from transtable;

Load * resident tab1 order by C desc, B asc, 1 desc;

Will that work?

Thanks,

Neil.

alexandros17 — Thu, 02 Jul 2015 15:28:13 GMT

tab1:

Select * from transtable;

Load * resident tab1 order by C desc, B asc, 1 desc;

it works and concatenates the 2 tables result, but why you do not order in the select?

MK_QSL — Thu, 02 Jul 2015 15:29:01 GMT

tab1:

Select * from transtable;

Noconcatenate

Load * resident tab1 order by C desc, B asc, 1 desc;

Drop Table tab1;

tinkerz1 — Thu, 02 Jul 2015 15:37:12 GMT

Can tab1 be empty?

I mean never be loaded into? So 'tab1:' initiates a blank table?

My problem is I use autonumber on a concatenated string to make it unique.

But I lose the order of the 2 elements in the sort order, ie name and location

So then I need to sort those 2 elements as sort by text does not work in a expression, I need to sort in the load order.