Skip to Content
0

outer join in Webi

May 22, 2017 at 04:57 PM

73

avatar image
Former Member

I got two columns like below:

want to perform left join to get result like:

How I can do it in Webi?

Currently I have outer join in UDT connecting table 1 and 2 on symbol column, but

I'm getting results without null values and nulls are essentail to my report.

sym.jpg (25.8 kB)
symbol2.jpg (22.7 kB)
sym.jpg (25.2 kB)
10 |10000 characters needed characters left characters exceeded

Hi,

Select RO,CO,Symbol as Table1 first and then Add Query by selecting WART, Symbol Table2.

WebI will look at Table1 as first table and then do a left join on Table2.

below is a quick view.

Thanks,

Jothi

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member May 22, 2017 at 09:13 PM
0

So I need to add two queries?

Share
10 |10000 characters needed characters left characters exceeded