User Profile
diego_martinezn
Frequent Visitor
Joined 4 years ago
User Widgets
Contributions
Re: PDF loading issues with power query
Hi v-jingzhang, thanks very much for replying. Your answer was very useful, I'll try changing the implementation to see if it changes something. On the other hand, I've tried to work with the pages but it's a complete mess, every page has a different number of columns and it's very difficult to automate that. But you gave me an idea, I'll try it. Thanks!PDF loading issues with power query
I've posted this question before, but it wasn't explained properly from de beginning and I think it's a good idea to start with the right food. So the situation is that I have a folder with some PDFs, while loading them, power query sometimes detects 2 tables and sometimes 3 tables. When I get 2 tables there are no issues. Both have the same number of columns and I just need to do some changes. After some transformations and putting both tables together, I end up with these columns: {Delegaciones, Total Revenues, Personnel Expenses, Subcontract, Other Expenses, Total Expenses, Gross Margin B. Activity, Indirect Costs Location, Gross Margin Location, Indirect Costs Location, Overheads, MB3} Where I'm having problems is when power query detects 3 tables instead of 2 for a different PDF, but it has the same structure as the previous one. In this particular case, the first table has 21 columns with some null columns I need to delete, etc (just like when I get 2 tables). After some transformations, I end up with the same columns I mentioned before. So there are no issues with the first table. The problems come with the second and third tables. First of all, instead of taking 21 columns with all the data (as it does with the first table or with the previous PDF), it takes in the second table 9 columns and in the third table 11 columns. The fact that doesn't let me continue is that when this happens, the column "Gross Margin B. Activity" disappears, it never gets loaded neither in table 2 or 3. So my questions here are two: If the PDFs have the exact same structure, why sometimes does it detect two tables and others 3? Is there something I can do to change this? If I can't change this fact, is there a solution to not losing that column when it detects three tables? Hope we can find a solution 🙂Re: Losing a column when importing PDF
Hi Anonymous , first of all, thank u for answering. Here it's what I've done based on your answer. I add a personalized column where I count the number of columns of each table and sort them, so what I get is three tables sorted as follows: {21columns, 11 columns, 9columns}. Then I click on the expand button, and as you said the whole new table has 21 columns but it fills with "nulls" where my missing data should be. I think this procedure is what you meant right? Maybe I'm skipping some steps or don't do it correctly. Let me know 🙂Re: Losing a column when importing PDF
Okay edhans , I'll try to explain better the issue: So, I have a folder with some PDFs, while loading them, power query sometimes detects 2 tables and sometimes 3 tables. I'm not going to focus a lot on this image cause when I get 2 tables there are no issues. What we need to know here is that both tables are loaded with 21 columns and the same structure (after loading I need to do some transformations but that's not a problem). Let's see when I get 3 tables: This is the case where I'm having problems. I get 3 tables instead of 2 for a different PDF, but it has the same structure as the previous one. In this particular case, the first table has 21 columns with some null columns I need to delete etc. After some transformations, I end up with these columns: {Delegaciones, Total Revenues, Personnel Expenses, Subcontract, Other Expenses, Total Expenses, Gross Margin B. Activity, Indirect Costs Location, Gross Margin Location, Indirect Costs Location, Overheads, MB3}. No issues with this first table. The problems come with the second and third tables. First of all, instead of taking 21 columns with all the data (as it does with the first table or with the previous PDF) it takes in the second table 9 columns and in the third table 11 columns. The fact that doesn't let me continue is that when this happens, the column "Gross Margin B. Activity" disappears, it never gets loaded neither in table 2 or 3. I hope I've explained myself and help you help me 🙂Re: Losing a column when importing PDF
Hi edhans Depending on the file (all have the same structure) it recognizes 2 or 3 tables. When there are 2 tables there are no problems, but when it recognizes 3 there is a column that is not loaded I don't know why. It's not that I deleted it during transformation or something like that, it is missing from the beginning.Re: Losing a column when importing PDF
Depending on the file (all have the same structure) it recognizes 2 or 3 tables. When there are 2 tables there are no problems, but when it recognizes 3 there is a column that is not loaded I don't know why. It's not that I deleted it during transformation or something like that, it is missing from the beginning.Losing a column when importing PDF
I'm working with a folder where I have some PDFs, all with the same structure. I've developed a function to just upload the files to that folder and automatically apply all transformations and operations to the table. However, I've noticed that power query sometimes recognize the PDF as 2 tables and sometimes as 3 tables. My main problem is that when it recognizes 3 tables, it skips one column of data that I need. Does this problem have any solution? Thank youRe: Power query loading PDF files wrong
Here are some photos of what I meant, there is no code at all (yet). Here we can see how, after loading the pdf, it detects 2 pages and 2 tables. Here, loading other PDF (with the exact same structure) it detects 3 tables and there is a missing column. It should always load 2 tables as the PDF are the same tables but with different data, but I don't understand why it isn't working. The main problem is the missing column by the way, if I could solve that problem it would be fine.Power query loading PDF files wrong
Good morning. I'm working with power query for power by to do a dashboard. I get my data from a folder where all the PDFs are located. All the files have the same structure (2 pages with the same number of columns). However, when I upload the files I get different results. For example, from one file power query recognize 2 tables with all the data correct, but for another one, it recognizes 3 tables where there is missing data. Why is this happening and how can I fix it? Thanks
