Get all cells between D3-D6 and to the right of undetermined number of columns

Help Studio
1

Hi there,
I am trying to read all values from D4 to D6 and any populated columns to the right of cells D4-D6. Number of columns populated will vary with each run. There is data below row 6 that I do not want to grab.
image
I have attempted to Read Range of “D4” then perform a While Loop to loop through just the first 3 rows but am getting an error “Input array is longer than number of columns in the table”.

image
image393×624 12.7 KB

1 Like
2

Hi @bambiCow

Can u show the screenshot of workflow

3

Hey @bambiCow,

Yes that’s right behaviour.

So to avoid that you need to first add the row which has max number of columns.

!! But doing this your row addition order may change, To avoid this as well

You can first find the max column count among the three rows & add those columns to the DT and then proceed with the data row addition.

Thanks :slight_smile:

4

Ended up removing all of the rows until just three remained in dt_Dcol datatable (see screenshot).

image
image576×628 14.4 KB

@Nithinkrishna can you please elaborate on what you are saying and add an image or upload your workflow? I tried add a datarow with the max columns and got the message: This row already belongs to another table.

1 Like
5

Hey @bambiCow,

I know, That approach is a little tedious and require querying.

But, the easiest way of doing it is to copy schema before trying to add in the new data table.

So, Before performing a while loop to add in new DataTable - Just clone old table to new as below in an assign.

image

This will copy the entire schema from old DataTable to the new DataTable in which you are trying to add.

Doing this will avoid, “Input array is longer than number of columns in the table” Error.

Then you can proceed with same adding logic after clone.

Hope this helps :slight_smile:

Thanks !

6

@Nithinkrishna sorry for my delayed reply. I cloned the data table first as you mentioned but received the error: “Add Data Row: This row already belongs to another table.”

image
image1247×519 21.6 KB

1 Like
7

Instead of using data row field in Add data row properties, please use Array Row field and pass dt_inputRange.Rows(counter).ItemArray

This should help, Thanks :slight_smile: