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.
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.
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.
@DavidP Bravo!
Thank you for the hint.