Read dynamic table in excel
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I am trying to read excel file which consist of two table and the position of table structure is inconsistent. Hence i have created column - "ReadPosition" using formula tool which define start and end position of table [PFA image].
I am facing and issue while separating this two tables
Solved! Go to Solution.
- Labels:
- Transformation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
With the Input Data tool, if you know the cell range of the data you want to load, you can specify it. For instance,
filename.xlsx|||Sheet1$A1:D10 will load data from cell A1 to cell D10
filename.xlsx|||Sheet1$A1:D will load data from cell A1 to Column D until the last row of data.
So if you can determine the cell ranges, you can use a dynamic input tool to load the specific range you want.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @DavidP ,
The range is not fix
Hence i have create a new column "ReadPosition" which will define the start and end of each table, as mentioned below.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@DavidP Bravo!
Thank you for the hint.