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.
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 
Ended up removing all of the rows until just three remained in dt_Dcol datatable (see screenshot).
@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.
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.
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
Thanks !
@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.”
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
