Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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;
Thanks a lot Sunny ! You brought sunlight on my trouble !
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;