Excel file with multiple tables on one sheet

2 posts / 0 new
Last post
qwin
Offline
Joined: 05/18/2022 - 04:05
Excel file with multiple tables on one sheet

Hello IDEA community
 
I have a large excel file of a client with multiple tables in one sheet. Is it now possible to split all the tables do different IDEA databases?
(I know that there are multiple ways to extract the data an create unique sheets per table but I wonder if there is a pure IDEA solution for that?)Thanks for any answer

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Unfortunately IDEA brings the files in by worksheet and not by tables.