•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Saving PQ file as CSV - Software that I am uploading it to says it sees values in my blank rows?
Our take
When saving a Power Query (PQ) file as a CSV, you might encounter an issue where your accounting software detects values in blank rows. This can be confusing, especially after manipulating data. The good news is that there are ways to ensure that unnecessary rows are cleared out within PQ before exporting. By addressing these empty rows directly in Power Query, you can streamline your upload process and eliminate any unintended data. Let’s explore the steps to resolve this issue effectively.
I feel like this is either a simple solution or a complicated one, but I've been looking at it for too long that my brain feels fried.
I basically have a file that I've manipulated in PQ. Say it has a header and two rows after the header of data. When I go to upload it into my accounting software, everything uploads fine, but the software thinks there are values in row 4 up to row 7.
Is there something that I can do in PQ to clear out all of the rows that aren't being used or is there something else I have to do outside of PQ?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- How to reduce Excel file size when using PP and PQ?I am using excel to combine other excel files and to do calculations on them, including average, std, but also more personalised equations (hence PP). Specifically, the purpose is to have "database" because I work with a lot of csv and excle files that I constantly need too extract information from (e.g. 50 files in all of which I only need 2 columns in 4th sheet), pain without PQ. Currently I am doing "create connection only" when loading queries, and I retrieve them using pivot table with filters, so at no point all of the information is retrieved. I am not sure what else I can do to reduce file size/improve performance. Current file size is about 55Mb, which is a lot. submitted by /u/3and12characters [link] [comments]
- Power Query - Manual Entry and Multiple UsersI have a file with details of open purchase orders. PO numbers are in the rows and there are several columns with various PO details. It is linked via PQ to two other files. It is used by multiple buyers and I'd like to dumb it down as much as possible. I need to be able to do two things that I haven't figured out yet: Each buyer is responsible for updating delivery ETAs on their open purchases. These are updated at different times for a each vendor throughout the week. In the shared file that we previously used, buyers had a sheet for each vendor and we used VLOOKUPS to pull data from these sheets. Obviously, that doesn't work with a PQ chart. Is there a solution to this that I'm not thinking of? I need a column where buyers can manually add notes to each cell. submitted by /u/free-range-human [link] [comments]
- Multiple Row Headers into PQ?I have a collection of PDFs I get weekly and I’d like to merge them together into one big query. However, the problem I run into is that dates are used as column headers. So if I batch load a folder of these documents, I see that row 27 for example might be the start of the new column headers. The data would look like this: Product 4/1 4/2 4/3 4/4 4/5 Apples 1 0 3 2 1 Oranges 1 5 3 2 7 It just changes those dates at the top when a new weekly PDF is cooked up. How do I solve for that in PQ? I’d like to be able to merge them together from a folder and update my pivot tables weekly based on what files are in the folder. submitted by /u/KyleTheTallOne [link] [comments]