In the invoice extraction,

krishnapriya_Anu · August 10, 2023, 5:13am

Taxonomy:

Pdf Contain:

Bill To
2.Ship To
3.PoNo
4.Date

Pdf Table Contain

1.Item-No
2.Quantity

And i don’t want the Item Column

I need a output like this

Usha_Jyothi · August 10, 2023, 5:15am

It is required another sheet to extract the table alone we can’t get the values and also table in one sheet
we can get table in one sheet and values in another sheet

mkankatala · August 10, 2023, 5:38am

Hi @krishnapriya_Anu

In Dataset.Tables(0) contains the header fields means Bill To, Ship To, PoNo, Date

The Line items means the table in the voice is stored in index of 2, Dataset.Tables(2)

Dataset.Tables(0) → which contains the header fields.
Dataset.Tables(1) → which contains the line items called table in the invoice.

Hope it helps!!

Shiva_Nikhil · August 10, 2023, 6:01am

hi @krishnapriya_Anu

replace the first merge datatable use for this in that place

leftside place CurrentRow.Item(“yourColumnName”)

repeat the steps for as per your column names

AMAN_GUPTA · August 10, 2023, 6:13am

Hi @krishnapriya_Anu ,

The best thing is to remove this column before writing the output excel file. To do you can use Remove Data Row/Column activity before write range, in which you can mention column name ‘item’ and in datatable field you can mention dtoutput.