How to add empty row above last line in data table

[E.T.S]

Hello,

I have a data table and would like to add an empty rows above the last line of the data table - please advise how I could do this

Cheers

[Parvathy (PS Parvathy)]

Hi @E.T.S

Try this:

dt = dt.Rows.InsertAt(dt.NewRow(), dt.Rows.Count - 1)

Hope it helps!!

[rlgandu (Rajyalakshmi Gandu)]

@E.T.S

Please put a input and output excel

[E.T.S]

Hi,

Thanks for your reply!

I get the following with the suggested method:

Cheers

[E.T.S]

HI,

Thanks for your reply!

Do you mean the input data table then the way I would like the data table to look

Cheers

[rlgandu (Rajyalakshmi Gandu)]

@E.T.S

Yes that is what i want

[E.T.S]

Input:

What I would like:

The number of rows of data are variable hence why I cannot just use an add row activity and specify where to add the row

Cheers!

[lrtetala (Lakshman Reddy)]

Hi @E.T.S

Can you try the below

YourDataTable.Rows.InsertAt(YourDataTable.NewRow(), YourDataTable.Rows.Count - Math.Min(1, YourDataTable.Rows.Count))

Input:

Output:

Cheers!!

[Parvathy (PS Parvathy)]

Hi @E.T.S

Use the below code in Invoke code:

dt.Rows.InsertAt(dt.NewRow(), dt.Rows.Count - 1)

Invoked Arguments:

Input:

Output:

Hope it helps!!

[E.T.S]

That works thank you!