How to do PDF extraction with dynamic data rows to excel

[supermanPunch (Arpan)]

@absithyd

Finally I am getting green highlighted data by doing string manupulation but i need to get red highlighed data.

Hi @absithyd ,

Could you maybe try to check using the workflow provided in the below post if it is able to identify the tables and extract. The Tables if able to identify, the output maybe a bit irregular. But we should be able to understand the pattern and adapt to correct :

PDF TABLES EXTRACTION EVEN WHEN ROWS ARE DYNAMIC

Hi @bhanusai_sajja , I believe the Sample PDF shared is a sample data only and not of confidential data. If it is confidential, Do Let me know. However, I am excluding the PDF sample that was provide to me in private. Check the below workflow : PDF_To_Excel_Corrected.zip (4.0 KB) The Data that you have provided, seemed to have some problem with the column name, and hence it was throwing out error. I did correct that part by implementing a counter/index to the column names if it was already h…

Let us know if the workflow gives out error or unable to extract the table.