Adding only the last 5 rows of datatable to queue

Help Activities
, , , ,
1

Hello everyone,

I am doing a pdf scraping case and I am stuck. I have a datatable with 6 columns. (Invoice number, vendor etc.) and I have to add the last 5 rows of this datatable to the queue.

How should I approach this?

I am new to UiPath so explicit answers would be the great. Thanks!

2

Hi @idil.konca

Welcome to Uipath community

How about this expression

DtBuild.asenumerable.reverse().take(5).copytodatatable

image

1 Like
3

Hi @idil.konca

Check out the XAML file

TakeLast5RecordFromDT.xaml (11.3 KB)

image
image388Ă—512 11.9 KB

Regards
Gokul

1 Like
4

wow, such quick response! Thank you. This is actually very useful. I have one more question, how to keep the first row as it is and add the last 5 under that first row?

6

You are taking about the Header ah ? @idil.konca

7

yes indeed. But my code does not work if I select the “use first row as column headers” inside datatable, I dont know why. That is why I am trying to find a workaround :slight_smile:

8

Hi @idil.konca

Can you share the sample excel file.

Do you have Duplicate column Header in the excel ?

9

I am a new user thus I cannot upload just yet I suppose :frowning: But I have regular 5 columns as;

  • Invoice_No
  • Tax_ID
  • Explanation
  • Total_Value
  • Currency
  • Date
10

HI @idil.konca

While Read the excel file enable this Add Header in the properties panel

image
image858Ă—201 14.7 KB

While adding the data into the queue it will take with the column names

Regards
Gokul

11

I actually read a pdf, write into text file, do some manipulations via invoke code, then get the output of code (datatable) and use it as an input. After all these I write it inside an Excel file.

12

Hi @idil.konca

Before writing into the Output value, You keep the column name has a template and append the output value in that excel.

After that use LINQ expression to take last 5 record from the excel.

Regards
Gokul

2 Likes
13

Thank you @Gokul001 !

14

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