topic How to select distinct rows in QlikView

How to select distinct rows

Mon, 25 May 2009 17:29:50 GMT

Hello

i have two tables

A B

1 1

2 2

3 3

B C

1 aaa

2 bbb

2 ccc

3 ddd

In result i need

A B C

1 1 aaa

2 2 bbb

3 3 ddd

How to select distinct rows

manishkumar75 — Mon, 25 May 2009 18:10:02 GMT

Hi Artur,

Plz see the attached example.

Hope it will work.

- Manish

How to select distinct rows

manishkumar75 — Mon, 25 May 2009 18:12:56 GMT

Hi Artur,

Plz see the attached example

Hope it will work.

- Manish

How to select distinct rows

Mon, 25 May 2009 18:42:11 GMT

I looked at attachment.

Thanks it works.

P.S.

You could write it like text

MapTable1:
Mapping Load * inline [ B, C
1 , aaa
2 , bbb
2, ccc
3 , ddd];

Table1:
Load * inline [ A, B
1 , 1
2 , 2
3 , 3];
Result:
Load A,B,applymap('MapTable1',B) as C
resident Table1;

drop table Table1;