Appending Data from PDF Table Number Two Problem

[nilxgusai14]

While appending second table data moving further colum

[SundarRaj · Accepted solution]

@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=104...

[v-vpabbu]

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 Pabbu

[v-vpabbu]

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 Pabbu

[v-vpabbu]

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 Pabbu

[Omid_Motamedise · Accepted solution]

Check column headers carefully in both tables before appending. Make sure columns are named exactly the same (case and spacing matter).

[SundarRaj · Accepted solution]

@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=104...

[nilxgusai14]

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. 

[SundarRaj]

Hi @nilxgusai14 ,
Can you send the file that you're working on, including the three tables you'd like to append. Thanks!