Regarding Left Outer Join

[Anonymous]

Hi ,

I have two table Names with Table A and Table B.

I need to do a Left Join Table B with Table A.

When I try below:

[Table B]:

left join ([Table A])

Load Name,

text,

.,.....;

[Table A]:

Load Name,

....;

when I do the above both the Table A and Table B, getting into a single table.

I want both the tables individual AND the left join should be done when pulling the columns from different tables into the visualization.

[sumanta12]

Hi,

Instead of left join use left keep.

[arvind_patil]

Hi ramesh,

You need to use Left Keep.

Thanks,

Arvind Patil

[Anonymous]

Sumanta, Thanks for the reply.

Ya, i looked into Keep as well while doing with left Join. So it can be used instead of Left Join.

Thanks for the update Sumanta.

[sumanta12]

Welcome Ramesh.