How to extract - Unstructured Excel file in to Data table

[Seem (S A)]

Hi Team,

I am having an excel file. The excel is Unstructered.
Now i want to extract the data from this excel. Based on the MODE : SEA IMPORT (this data i get from .pdf)

So now i have highlighted the tables in the yellow color.
I have to extract the based on the MODE — IMPORT - SEA - SEA - LCL.

how can i do this.

Please help me

Seema

[AshwinS2 (Ashwin S)]

Hi @Seem

Have you tried using with Generated Data table activity

Thanks
Ashwin S

[supermanPunch (Arpan)]

@Seem Can you provide us the Excel File?

[Seem (S A)]

yeah sure
Please find it thereNew KWE Rate 2020.xlsx (22.0 KB)

[Seem (S A)]

@AshwinS2

the Generate Data table - is to generate the table from the web scraping right ?

I actually take the data tables from the existing excel …
Can you please help me…

[supermanPunch (Arpan)]

@Seem Check this Workflow , If it works ,and if it is What you needed, It may not be the best way to get it ExtractTableFromTable.zip (25.9 KB)