Unable to apply a loop to extract multiple values from single pdf

Help
1

Greetings!

I am new to UiPath and trying to make a workflow where i have a list of company names in a pdf file and i need to get their current rate from a website and save that data in a excel file.

I have made a workflow which does this however, only for the first value. The rest of the names in the file arent getting extracted and i am facing a challenge to apply a loop to this workflow.

Note: I am not using the PDF to excel activity as currently this isn’t available in the list of packages.

Kindly help with a suggestion or a solution for the above.

Thanks in advance!

2

Hi @Heena_Thakkar

Try to do string manipulations of extract pdf with string variables

Thanks
Ashwin.S

1 Like
3

Extract the values by string manipulations and store them in datatable and then apply “for each row” activity and use excel, apply the datatable in excel worksheet.

1 Like
4

Thank you for the quick response @AshwinS2 and @VenkatDurbha !!

I will try the string manipulation method and confirm.:slightly_smiling_face:

1 Like
5

No problem :slight_smile: