Data modelling based on joins or concatenate

[Mapuna]

load * inline
[Accounid, Owner, 1owner, 2owner
1, a1, a,g
2, b2, b,2e
3, c3, c
4, d4, d
20, a
21, b
22, c
23, d
24, g
28, d
29, 2e
];

consider the above table

when i select 'a' from 1owner field i was to show data corresponding to Accountid row 1 and row 20

in this way:

how to achieve this? kindly help

[PrashantSangle]

Hi,

try below

Test:
load * inline [
Accounid, Owner, owner1, owner2
1, a1, a,g
2, b2, b,2e
3, c3, c
4, d4, d
20, a
21, b
22, c
23, d
24, g
28, d
29, 2e
];

NoConcatenate
Final:
Load Accounid,
Owner
Resident Test;
Concatenate
Load Accounid,
owner1 as Owner
Resident Test;
Concatenate
Load Accounid,
owner2 as Owner
Resident Test;

Drop table Test;

Regards,

Prashant Sangle