1 Reply Latest reply on Jan 31, 2019 10:22 AM by Hari Ankem

    Cross DB Join with Oracle & Excel

    David Hofberg

      I am trying to bring in an excel file (hosted on sharepoint) and join to an oracle connection.  When I add the excel table to the data model, some of the joins error out, the only one that provides an error message states that the number types are different (whole vs. decimal), but this only is an issue once the excel file is added.  I found another conversation that had a similar issue and they were able to change the data type in excel to a decimal. The only number field in my excel file is already a decimal. Thanks