noveske
Board Regular
- Joined
- Apr 15, 2022
- Messages
- 120
- Office Version
- 365
- Platform
- Windows
- Mobile
- Web
The .pdf varies from 1 to 2 pages. .pdf format is consistent.
When selecting source, the query is inconsistent. When the pdf is filled in the last column, it's random which ones are copied or, then instead of placing the data in the right cell in PQ, it will add it to the end of the _______________. It doesn't copy all even when all fields are filled.
Hiding null rows and manipulating it to be what I need is easy. I've been doing it as separate queries. Then combining them after cutting everything I don't need out. I only need 5 of the columns.
Could parameters to be set to only pull specific columns containing specific data types then instructed to query to specific columns?
Column 1: Last Name, First Name separated by the comma. Last, First
Column 2: 6 - character letter and number combination. (XX0000)
Column 3: Usually 1-2 characters - Letter - Number - 3 Numbers - 2 Numbers. ( X-X-0-000-00)
Column 4: 1 or 2 words.
Column 5: 10-digit number.
Just gets thrown off when the file is replaced and then refreshed. Even though the .pdf is the same format every time.
So sometimes it will pull 10 columns, others 11.
Column 6 and 7 on the .pdf are blank or have a value. This is just random.
How would I make it into one query so when the file gets replaced, I can just refresh it to pull what I need?
When I set it up, it works. But then after updating the original file which is the same format each time, something shifts.
Key mismatch error. I get why it's erroring, but can't find a solution.
PQ, Table001: Column 6 is just added. No header. Not even there on the .pdf. When there's only 1 page and I update the .pdf, PQ will show it sometimes.
When selecting source, the query is inconsistent. When the pdf is filled in the last column, it's random which ones are copied or, then instead of placing the data in the right cell in PQ, it will add it to the end of the _______________. It doesn't copy all even when all fields are filled.
Hiding null rows and manipulating it to be what I need is easy. I've been doing it as separate queries. Then combining them after cutting everything I don't need out. I only need 5 of the columns.
Could parameters to be set to only pull specific columns containing specific data types then instructed to query to specific columns?
Column 1: Last Name, First Name separated by the comma. Last, First
Column 2: 6 - character letter and number combination. (XX0000)
Column 3: Usually 1-2 characters - Letter - Number - 3 Numbers - 2 Numbers. ( X-X-0-000-00)
Column 4: 1 or 2 words.
Column 5: 10-digit number.
Just gets thrown off when the file is replaced and then refreshed. Even though the .pdf is the same format every time.
So sometimes it will pull 10 columns, others 11.
Column 6 and 7 on the .pdf are blank or have a value. This is just random.
How would I make it into one query so when the file gets replaced, I can just refresh it to pull what I need?
When I set it up, it works. But then after updating the original file which is the same format each time, something shifts.
Key mismatch error. I get why it's erroring, but can't find a solution.
PQ, Table001: Column 6 is just added. No header. Not even there on the .pdf. When there's only 1 page and I update the .pdf, PQ will show it sometimes.
Last edited: