joining requirement, help required in set analysis

[svsudhakar]

Hi ,

Need help on below issue.

I have two tables A,B

Table A

LUSERID
LOCID

AUSERID

Table B

USERID

LOCID

Value

I need to show the LUSERID,LOCID  wise values and as well as AUSERID,LOCID wise value.

if I create the key like LUSERID&LOCID from table A and USERID&LOCID from table B values are matching, but Auserid report not coming.

if I create the key like AUSERID&LOCID from table A and USERID&LOCID from table B values are matching, but luserid report not coming.

how I can show in one report both values.

[alexandros17]

do not create keys just:

TableA

left join

TableB

Let me know

[#3]

Hi,

Table A

Left(Table A)

Table B:

or else use Left Keep

[its_anandrjs]

One possible way also join this tables and make use of Order BY

TableA:

LUSERID
LOCID

AUSERID

Left Join(TableA)

TableB:

USERID

LOCID

Value

Noconcatenate

Load

LUSERID
LOCID

AUSERID

USERID

Value

Resident TableA

Order BY LUSERID,AUSERID,LOCID;

Drop Table TableA;

Regards

Anand

[svsudhakar]

Hi Thanks for your reply..

Is there any way to get the values with out join because other tables are linked to table A. If I do the join it will effect the other reports.

[svsudhakar]

Hi ,

Based on which filed I have to do the left join

[ashfaq_haseeb]

LOCID

Which is key field

[alexandros17]

You can have the same result even if you do not perform the join.

Load both tables, you will have all values because tables will associate on common fields (similar to join)

Let me know