Power query multiple pdf files

New Contributor

Hi

 

I need to help sorting below data into dates and hours

Separate pdf file for each date, is it easier to export them separately? Date is in the pdf file but not in the table I'm trying to export

sachi2170_0-1673038328892.png

5 Replies

@sachi2170 

Could you please clarify what exactly you'd like to do - get content of the PDF file and extract some information from it; or convert name of PDF file into the date; or something else?

@Sergei Baklan 

I have 7 pdf files for each day. I need the data in them categorised into hourly instead of half an hourly 

@sachi2170 

So, on your screenshot you'd like Column2 and Column3 to be presented on hourly basis, first column doesn't matter? If so, what is in column 3 - min, max, average, sum, something else?

Column 3 has half an hour sales, need half an hour sales combined to hourly sales

@sachi2170 

If something like

image.png

and without coding, that could be done as in attached file