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

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 hundreds of Community platforms