My Oracle Support Banner

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

Last updated on JUNE 20, 2018

Applies to:

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

Symptoms

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.

Changes

 

Cause

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

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


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