Read dynamic table in excel

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

Input.JPG

Transformation

Accepted answers

DavidP

If there are some keywords you can pick up for the start of each table, for instance "Amount" in your example, you can create some logic to separate the tables.

I've mocked up an example based on your sample data.

separate tables with multirow.yxmd

All comments

DavidP

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.

GayatriPanigrahi

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703