Hello everyone !

Need help on how to iterate the excel value every 10 rows.

Actually, I need to copy all these value

to that sheet

Thanks in advance!

Hello everyone !

Need help on how to iterate the excel value every 10 rows.

Actually, I need to copy all these value

to that sheet

Thanks in advance!

As you can see, first need to copy the value in the 20220622 row, after that to the 20220623 row.

Dt2 = Dt1.Clone Dt2=Dt1.AsEnumerable().Take(10).CopyToDataTable()

Thank you. But can you explain a lil bit how to use that code? Iâ€™m sorry, noob here.

Hello!

First use activity read range with source range (â€śD2:D12â€ť for example) without checking â€śAddHeadersâ€ť and storing the data in a DataTable. Then use the write range activity with target range (â€śF2â€ť for example) without checking â€śAddHeadersâ€ť to write the DataTable data.

Thank you.

But after that, I want to copy the value but need to paste on the 20220623 row. So, can I know the solution how to do that

Hi @fizzuraimi

If the first table is given like this

and the second excel is like this

Then you can proceed like this

XAML for reference

10Rows.xaml (7.3 KB)

1 Like

Dt1.AsEnumerable.Skip(0).Take(10)

Dt1.AsEnumerable.Skip(10).Take(10)

Dt1.AsEnumerable. Skip(20).Take(10) etxc etc

Based on the number of row you can perform

This is basically a combination of skip and take function

In the first case it will take first 10 and skip none

In second case will skip first 10 cases and take the rest 10 and so on

Thank you for your solution. But can you give some example how to use that?

1 Like

Hi @fizzuraimi

lets say you want only first 10 rows of that excel

Dt1.AsEnumerable.Skip(0).Take(10)

so this means --Take (10) would take first 10 rows and skip (0) means no skip

DT1 is ur datatable name

hope this helps

thanks

Oh I see, so do I need to use assign activity to put that coding?

1 Like

change the type of dt_Input variable to datatable