My Oracle Support Banner

Unable To Join Two Excel Spreadsheets In BI Publisher (Doc ID 2413272.1)

Last updated on DECEMBER 03, 2019

Applies to:

BI Publisher (formerly XML Publisher) - Version 12.1.3 and later
Information in this document applies to any platform.


Unable to Create data model my joining 2 Xlsx file.


1. Click New --> Data Model from menu

2. Click ”+” within the Diagram tab

3.Add Microsoft Excel file “Test1.xlsx” and then “Test2.xlsx”

4. Click on the diagram and drag a link from one column of “Test1.xlsx” to another column of “Test2.xlsx”

5.Click on the Data tab, then the View button.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.