https://community.fabric.microsoft.com/t5/Power-Query/Appending-Data-from-PDF-Table-Number-Two-Problem/m-p/4707973#M151237 <P><img /></P><P>&nbsp;</P><P>While appending second table data moving further colum</P> Mon, 26 May 2025 19:25:26 GMT nilxgusai14 2025-05-26T19:25:26Z https://community.fabric.microsoft.com/t5/Power-Query/Appending-Data-from-PDF-Table-Number-Two-Problem/m-p/4707973#M151237 <P><img /></P><P>&nbsp;</P><P>While appending second table data moving further colum</P> Mon, 26 May 2025 19:25:26 GMT https://community.fabric.microsoft.com/t5/Power-Query/Appending-Data-from-PDF-Table-Number-Two-Problem/m-p/4707973#M151237 nilxgusai14 2025-05-26T19:25:26Z https://community.fabric.microsoft.com/t5/Power-Query/Appending-Data-from-PDF-Table-Number-Two-Problem/m-p/4708178#M151244 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="1282026" data-lia-user-login="nilxgusai14" class="lia-mention lia-mention-user">nilxgusai14</a>&nbsp;,<BR />Can you send the file that you're working on, including the three tables you'd like to append. Thanks!</P> Tue, 27 May 2025 04:56:01 GMT https://community.fabric.microsoft.com/t5/Power-Query/Appending-Data-from-PDF-Table-Number-Two-Problem/m-p/4708178#M151244 SundarRaj 2025-05-27T04:56:01Z https://community.fabric.microsoft.com/t5/Power-Query/Appending-Data-from-PDF-Table-Number-Two-Problem/m-p/4708275#M151251 <P>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.&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 27 May 2025 06:04:15 GMT https://community.fabric.microsoft.com/t5/Power-Query/Appending-Data-from-PDF-Table-Number-Two-Problem/m-p/4708275#M151251 nilxgusai14 2025-05-27T06:04:15Z https://community.fabric.microsoft.com/t5/Power-Query/Appending-Data-from-PDF-Table-Number-Two-Problem/m-p/4708617#M151254 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="1282026" data-lia-user-login="nilxgusai14" class="lia-mention lia-mention-user">nilxgusai14</a><BR />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<BR /><BR />Here's the file link: (Please download it and open the PQ Editor)<BR /><A href="https://docs.google.com/spreadsheets/d/1Ye5Fl4yH5uU6EZA0WSLcejaNQZaa8oIe/edit?usp=sharing&amp;ouid=104752674875039603034&amp;rtpof=true&amp;sd=true" target="_blank" rel="noopener">https://docs.google.com/spreadsheets/d/1Ye5Fl4yH5uU6EZA0WSLcejaNQZaa8oIe/export?format=xlsx&amp;ouid=104752674875039603034&amp;rtpof=true&amp;sd=true</A><BR /><BR /><BR /></P><P><img /></P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Tue, 27 May 2025 09:06:41 GMT https://community.fabric.microsoft.com/t5/Power-Query/Appending-Data-from-PDF-Table-Number-Two-Problem/m-p/4708617#M151254 SundarRaj 2025-05-27T09:06:41Z https://community.fabric.microsoft.com/t5/Power-Query/Appending-Data-from-PDF-Table-Number-Two-Problem/m-p/4711151#M151344 <P>Check column headers carefully in both tables before appending. Make sure columns are named exactly the same (case and spacing matter).</P> Thu, 29 May 2025 02:29:05 GMT https://community.fabric.microsoft.com/t5/Power-Query/Appending-Data-from-PDF-Table-Number-Two-Problem/m-p/4711151#M151344 Omid_Motamedise 2025-05-29T02:29:05Z https://community.fabric.microsoft.com/t5/Power-Query/Appending-Data-from-PDF-Table-Number-Two-Problem/m-p/4714189#M151471 <P>Hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="1282026" data-lia-user-login="nilxgusai14" class="lia-mention lia-mention-user">nilxgusai14</a>,</P> <P>&nbsp;</P> <P>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.<BR />If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.</P> <P>&nbsp;</P> <P>Regards,<BR />Vinay Pabbu</P> Fri, 30 May 2025 13:29:19 GMT https://community.fabric.microsoft.com/t5/Power-Query/Appending-Data-from-PDF-Table-Number-Two-Problem/m-p/4714189#M151471 Anonymous 2025-05-30T13:29:19Z https://community.fabric.microsoft.com/t5/Power-Query/Appending-Data-from-PDF-Table-Number-Two-Problem/m-p/4716904#M151577 <P>Hi<SPAN>&nbsp;</SPAN><A href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/1282026" target="_blank">@nilxgusai14</A>,</P> <P>&nbsp;</P> <P>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.<BR />If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.</P> <P>&nbsp;</P> <P>Regards,<BR />Vinay Pabbu</P> Mon, 02 Jun 2025 12:11:11 GMT https://community.fabric.microsoft.com/t5/Power-Query/Appending-Data-from-PDF-Table-Number-Two-Problem/m-p/4716904#M151577 Anonymous 2025-06-02T12:11:11Z https://community.fabric.microsoft.com/t5/Power-Query/Appending-Data-from-PDF-Table-Number-Two-Problem/m-p/4721487#M151737 <P>Hi<SPAN>&nbsp;</SPAN><A href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/1282026" target="_blank" rel="noopener">@nilxgusai14</A>,</P> <P>&nbsp;</P> <P>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.<BR />If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.</P> <P>&nbsp;</P> <P>Regards,<BR />Vinay Pabbu</P> Thu, 05 Jun 2025 13:02:07 GMT https://community.fabric.microsoft.com/t5/Power-Query/Appending-Data-from-PDF-Table-Number-Two-Problem/m-p/4721487#M151737 Anonymous 2025-06-05T13:02:07Z