topic Re: How to sort a table in another order than load order in QlikView

How to sort a table in another order than load order

phb_nostromo — Tue, 22 Mar 2016 13:15:59 GMT

Hello,

Please excuse for my english and the newbie aspect to QlikView in the question i have to submit ...

It seems simple, and easy under excel.. but i need to know how could i get the value of the column LineNumber for the first value of Pandora_key. That's done in order to remove duplicates from a far bigger table.

Pandora_key	LineNumber
1	1
2	2
3	3
4	4
4	5
6	6
7	7
7	8
8	9
9	10
9	11
9	12
9	13
9	14
9	15
9	16
9	17
9	18
9	19
9	20
9	21
10	22
10	23

So here for instance, i'd like to have LineNumber = 1 for Pandora_key = 1, 10 for 9, 22 for 10.

The code is :

[TableBrute]:

LOAD distinct

Pandora_key,

recno() as LineNumber

FROM

(qvd);

Table:

load Pandora_key, LineNumber resident TableBrute

where previous(Pandora_key) <> Pandora_key

order by Pandora_key, ;

Could anybody help me Please ??

Thanks a million . I'm getting stuck here

Re: How to sort a table in another order than load order

sunny_talwar — Tue, 22 Mar 2016 13:34:08 GMT

This?

Script:

Table:

LOAD Pandora_key,

RecNo() as TempLineNumber

FROM

[https://community.qlik.com/thread/210457]

(html, codepage is 1252, embedded labels, table is @1);

Join(Table)

LOAD Pandora_key,

Min(TempLineNumber) as LineNumber

Resident Table

Group By Pandora_key;

Re: How to sort a table in another order than load order

phb_nostromo — Tue, 22 Mar 2016 13:46:59 GMT

Thanks a lot Sunny ! You brought sunlight on my trouble !

Re: How to sort a table in another order than load order

Digvijay_Singh — Tue, 22 Mar 2016 14:13:55 GMT

t1:

Load * inline [

Pandora_key LineNumber

1 1

2 2

3 3

4 4

4 5

6 6

7 7

7 8

8 9

9 10

9 11

9 12

9 13

9 14

9 15

9 16

9 17

9 18

9 19

9 20

9 21

10 22

10 23 ](delimiter is spaces);

NoConcatenate

Table:

load Pandora_key,

min(LineNumber) as LineNumber

Resident t1

Group By Pandora_key;

Drop table t1;