Uipath append activity only take the last row

[farrissya.z]

Hi, I’m a beginner in UiPath for the last 2 months. Question is, I extracted data table from multiple pdfs. According to local panel, it extracted the whole table. but when i append into a single excel sheet, it only appends the last row starting from the second pdf. Sorry, can’t show data due to data confidentiality. Thank you.

Note : I removed the first row because it did not detect it as header. So I build a data table for header.

[supermanPunch (Arpan)]

Hi @farrissya.z ,

From the Screenshot we can see that there are two datatables being used. Isn’t ExtractDatatable variable the one that needs to be used in Write Range activity ?

[Usha_Jyothi]

you need to use dt_new for the append as mentioned in your scenario

[farrissya.z]

the first write range is only to add headers. while the second is to add the data

[supriya117 (Supriya Allada)]

Hi @farrissya.z

Use build datatable activity and write range activity before the loop.

[NIVED_NAMBIAR (NIVED N)]

Hi @farrissya.z

Could you tell what was the output of ExtractedDatatable.Rows.Count value in log message ?

[Kartheek_Battu]

Hello @farrissya.z

<ExcelApplicationScope>
    <WriteRange Range="A1" DataTable="[yourDataTable]" />

    <!-- For Each PDF -->
    <!-- Extract data into 'extractedDataTable' -->

    <WriteRange Range="A2" DataTable="[extractedDataTable]" />
</ExcelApplicationScope>

Thanks & Cheers!!!

[farrissya.z]

it just to display the table row count. for the first pdf, it has 3 rows

[farrissya.z]

i just realized why it take the last row only. apparently, for the first pdf, the table extraction extracted the header as row. so i deleted the first row and added a new header. and i found out that for the second pdf, the table extraction activity did recognize the header. but, i already deleted the first row. that’s why i have only the last row. is there a way to filter if the first row have the header or not so i can delete the first row?

[supermanPunch (Arpan)]

@farrissya.z

is there a way to filter if the first row have the header or not

@farrissya.z ,

Could try with Filter Datatable activity with reference to the First Column being header name and then perform removal of the rows.

[farrissya.z]

I’ll try this first. thank you!