Forum Discussion
Solved
Appending Data from PDF Table Number Two Problem
While appending second table data moving further colum
nilxgusai14
I just took a dummy data from an external source. I'll share the output, M code and the file as well. Do have a look at it. Thanks
Here's the file link: (Please download it and open the PQ Editor)
https://docs.google.com/spreadsheets/d/1Ye5Fl4yH5uU6EZA0WSLcejaNQZaa8oIe/export?format=xlsx&ouid=104752674875039603034&rtpof=true&sd=trueCheck column headers carefully in both tables before appending. Make sure columns are named exactly the same (case and spacing matter).
Actully its pdf file i tried converting in excel but, second and third table mismatch, move to extra column. this is example file i am taking, i want to know how to fix because i have lots of pdf which need to convert data into excel.