In the invoice extraction,

[krishnapriya_Anu]

Taxonomy:

Pdf Contain:

1. 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]

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 (Mahesh Kankatala)]

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]

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]

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.

[krishnapriya_Anu]

Okay

this id correct ? Merger Data Table

[Shiva_Nikhil]

hi @krishnapriya_Anu

yes

[krishnapriya_Anu]

this is Correct for ship to

[Shiva_Nikhil]

hi @krishnapriya_Anu
yes

[krishnapriya_Anu]

But if i give this table(0).rows(0)

Ship is Empty

[Shiva_Nikhil]

hi @krishnapriya

can you place a log message or message box below assign activity
check this once the data is present in that or not