Hi there,
I am using table extraction activity to extract information from pdf. The table extraction extracts information and save it as datatable. However i wan to take out a certain value to write in another excel. How do i go about without using regex or writing in blank excel and then save it as variable and then write into another excel?
@mark_rajkumar1 you need to share the details
From where do you want to pull data and store it in Excel?
What Data do you want to store in DB and Excel?
are you able to extract data 100% from PDF?
Is PDF native?
Why you don’t want to use the regex?
writing in blank Excel and then saving it as a variable and then writing into another Excel (pls explain in more detail)
Pls share the input?
Hi @mukesh.singh i am extracting from pdf. I canpull out from pdf 100% but in different datataables. The excel i wan to write is a structured one but however when i extract the rows n column change but its fixed. So from there i wan to read some infornation and write to a structured excel table.
Hi Mark, Do you have any keyword conditioned to extract the row? Or do you know from which column number or row number it has to extract ? Any such information would be helpful
Hi @pavankumar267 i extract the whole pdf with 3 parts header, table and bottom. The header contains 5 rows, table 12 rows and bottom is 4 rows. This pdf orgin is an excel which has been converted to pdf.
ok. what i understood is you want to extract data properly from those 12 rows. Btw, Is it possible to share the sample data (may not be original data, but with some random data, but in original format) ?