Extract multiple file PDf in one folder to excel

[mycroft7]

Hello, need help…i have case to extract PDf with regex, i created flow to extract pdf in one file pdf and its working well (main.xaml) And For result excel its like below:
Main.xaml (13.1 KB)

And now i need to extract more than one file in same folder to extract, i have create flow(extractMultiFilesPDf), but its still getting erorr. Please advise.

Thanks in advance.

ExtractMultiFilesPDF.xaml (14.4 KB)

[LAKSHMI_NARAYANA_PEMMASAN (LAKSHMI NARAYANA)]

can you try this

ExtractMultiFilesPDF.xaml (14.6 KB)

regards

[mycroft7]

still eror

[sasi_poosarla (sasi p)]

write range Workbook activity should be outside of for each activity…

[Shiva_Nikhil]

can you please check the varaibles of getFCR,getInvGGI and other varaibles placed in add datarow

[rmorgan]

Whatever you are trying to right in the array isn’t their ie its blank and it won’t accept blank input.

Suggest writing each element you are extracting to a textfile and checking which one isn’t present

[mycroft7]

still cannot

[mycroft7]

no idea for this…

[LAKSHMI_NARAYANA_PEMMASAN (LAKSHMI NARAYANA)]

check the regex with text in the pdf are you getting any output or not

if still you face any issue please sample pdf files with expected output

Edit - Also try change value in data row in this way {getFCR,getInvGGI,getInvExpd,getValueVAT}

Regards

[mycroft7]

Please See my first post in this thread, i have create Flow to exctract with 1 file PDF(main.xaml), and running well, see also in screen shoot.

[mycroft7]

@supermanPunch can you help me?thank you…

[LAKSHMI_NARAYANA_PEMMASAN (LAKSHMI NARAYANA)]

@LAKSHMI_NARAYANA_PEMMASAN

{getFCR,getInvGGI,getInvExpd,getValueVAT}

try as above it will work

Regards

[mycroft7]

still eror

ExtractMultiFilesPDF.xaml (14.7 KB)

[LAKSHMI_NARAYANA_PEMMASAN (LAKSHMI NARAYANA)]

see this is not the file i gave , you are not providing output to read pdf activity

so i made some adjustments and created separate variable to avoid this

in this way it will not work right?

so better make changes as provided

Regards

[mycroft7]

sory wrong attch file, i have make correction for this. stil showing eror like before
ExtractMultiFilesPDF.xaml (14.8 KB)

[LAKSHMI_NARAYANA_PEMMASAN (LAKSHMI NARAYANA)]

you have changed the in read pdf activity but again missed giving that to matches activity

so change input for all matches activity with the output of read pdf activity

also still if you face issue please provide details at what activity you are getting error

along with total error details in locals panel

Regards

[mycroft7]

sory my bad… i have changed all the matches with the variable on read PDF, stil getting error, the activy is in add data row, like below

[LAKSHMI_NARAYANA_PEMMASAN (LAKSHMI NARAYANA)]

there are two dtoutput datatable

try deleting the first and try again now

Regards

[mycroft7]

@LAKSHMI_NARAYANA_PEMMASAN

so i made some adjustments and created separate variable to avoid this

thanks @LAKSHMI_NARAYANA_PEMMASAN its working now… many thanks