Forum Discussion
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).
7 Replies
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=trueHi nilxgusai14 ,
Can you send the file that you're working on, including the three tables you'd like to append. Thanks!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.
Check column headers carefully in both tables before appending. Make sure columns are named exactly the same (case and spacing matter).
Hi nilxgusai14,
As we haven’t heard back from you, we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Regards,
Vinay PabbuHi @nilxgusai14,
As we haven’t heard back from you, we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Regards,
Vinay PabbuHi @nilxgusai14,
As we haven’t heard back from you, we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Regards,
Vinay Pabbu
