Adding Blank rows

Continuing the discussion from How to add Blank row, before row value chages:

Hi @Yoichi,

My Invoke Method is giving an error:

Please help.


Can you share screenshot of setting of Parameters? There may be misconfiguration.


Solved that @Yoichi. Thanks.

Hi @yash.choursia

Please use the below linq expression,

(From row In inputDataTable.AsEnumerable()
Let rank = row("Rankings").ToString()
Let count = inputDataTable.AsEnumerable().Count(Function(r) r("Rankings").ToString() = rank)
Let newRow = If(count >= 1 AndAlso row.Equals(inputDataTable.AsEnumerable().Last(Function(r) r("Rankings").ToString() = rank)), inputDataTable.NewRow(), Nothing)
Select row, newRow).SelectMany(Function(x) If(x.newRow IsNot Nothing, {x.row, x.newRow}, {x.row})).CopyToDataTable()

Hope it helps!!


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.