How to select distinct rows

[#1]

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

[manishkumar75]

Hi Artur,

Plz see the attached example.

Hope it will work.

- Manish

[manishkumar75 · Accepted solution]

Hi Artur,

Plz see the attached example

Hope it will work.

- Manish

[#4]

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;

"