Write datatable but creates extra rows

[mark_rajkumar1 (mar)]

@postwick how about removing a column from datatable?

[postwick (Paul Ostwick)]

Use the DefaultView.ToTable expression to remove and reorder columns in one step. It will only return the columns you specify in the expression, and it will return them in the order you specify.

[Gautham_Pattabiraman]

Hi @mark_rajkumar1 ,

Add an if condition as first step inside for each row,
Assume you have a data table consisting of n rows (5 rows) and you are starting to write first row of data table in cell I 11 you need to break once it reaches I 16.

Add an if condition inside for each row something like Counter <16, in then part (condition is true) add your steps to write in cell and to increment

In the else part put a break to break out of the loop this way you should be able to exit the loop after writing exactly n rows.

How to determine the Max count (16) ?

Use an assign activity, Create a variable MaxCounter of type Int32,

Dt_SampleTable.Rows.count + 1

Replace Dt_SampleTable with the data table variable you are using.

Please try this method once and let me know.

Thanks,
Gautham.