As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at firstname.lastname@example.org and provide your corporate email address, company, and name.
Hi All, I am struggling with using JOIN function in WebFocus report to get result as left outer join. No matter what I do, I always get result as inner join. Is there a syntax format to be used? My code is as such:
JOIN REGION_ID IN USER_DATA TO UNIQUE REGION_ID IN DIM_REGIONS TAG J1 AS J1 END
TABLE FILE USER_DATA BY USER_DATA.REGION_ID BY J1.REGION SUM UNITS\I8C
I would like this report to show all Regions in User Data that are both, matched and not matched to DIm_Regions.
WebFOCUS 7.7, iWay Data Migrator, Windows Excel, PDF, HTML, XML