Looking for HOW TO for users to connect Excel in "My Project"

#1

I know that within Dundas if a user is a power user that they can import spreadsheets and link two sets of data based on a common column in the two files. I swear I’ve done this, but none of my google searches or searching in Dundas support is showing examples of how to do this.

I would like my users to be able to do this for themselves so I can stop importing excel into Oracle to do a cross reference of data based on spreadsheets.

Is there a HOW TO on how to do this that anyone has found is helpful for USERS of Dundas to achieve what I’m trying to do? Not developers or system admins, I need simple clear instructions with lots of screenshots. I’d rather not have to rewrite instructions that should exist out there…

#2

how to connect to Excel:
https://www.dundas.com/support/learning/documentation/connect-to-data/how-to/connecting-to-excel

ho to do joins in Dundas:
https://www.dundas.com/Support/learning/videos-tutorials/data-cubes/introduction-to-data-cubes

The over all thing you want to do is broken down into two main task that both have instructions.

3 Likes
#3

Thanks so much @james.davis!

I had it in my head that there was a written version of how to do the joins. I’ll pass along this information. Hopefully the idea of an eight-minute long video won’t deter my user from trying.