Power Query Joins and More Columns than Expected
In Microsofts Power Query, I'm trying to Merge (i.e. Join) two sources, and I'm getting a mysterious error.
I have a source file which is a large csv data dump. I read it in and clean it, unpivot some data, and load it as a Connection-only. Here's a preview of the Connection-Only:
The second source is a 1 column table. Here's its Preview:
Finally, I'm merging them, with this code, and getting this error:
I get the same error using Table.Join. I've tried changing the order of the two tables to the join, but no joy.
Oddly, everything works fine while I'm in the query-editor. It's only when I Load and Close that I hit the error.
Any idea what's causing it? Alternatively, any workarounds?
My hypothesis is that one of the values in the CSV file has a comma in the Part No, which makes it think that number spans two columns and you're left with an extra column.
The reason it works in the query editor but not when you close and load is probably because the editor only loads a preview of the rows and the error occurs not in the previewed section.
You might be able to resolve the issue by filtering out that one row with a comma in it (assuming my hypothesis is correct). Another option would be to load it as a text file and try splitting the columns in the query editor instead of relying on the CSV import to automatically handle it correctly.
- Why is LEFT INNER JOIN deprecated?
- Fetch posgresql data in JSON format including both filtered and non-filtered data
- join 3 tables in a view
- Why does this INNER JOIN query return all rows instead of just the one matching?
- UPDATE Statement ignores INNER JOIN
- How to use an UPDATE Query with an INNER JOIN to update fields within a table
- How to inner-join in Excel (eg. using VLOOKUP)
- What is the difference between "INNER JOIN" and "OUTER JOIN"?
- Year range and SUM from two tables using Inner Join
- Understanding inner join in recursive CTE (MySQL)
- Perform an INNER JOIN with more than 2 tables in MySQL
- How to apply several selects for several joins?
- How to make an Inner Join in django?
- SQL Query inner join with specific data
- How to query all the ID of the first table with the last Event and the first Date on the second table related one-to-many to the first?
- How to get data from 2 api and view data in angular material table?
- MongoDB Join filter, input, as, if, eq _id exists
- How to fetch uncommon data from two different tables in Oracle SQL (query A - query B)
- How do I write a query for inner join
- Laravel scope with inner join
- how to use sql innerjoin of two columns criteria from one table in an MS access database
- Use INNER JOIN instead of LEFT JOIN when using gorm .Joins
- Update statement with inner join on Oracle
- Is there any way to filter based on two tables
- Mysql range check instead of index usage on inner join
- SQL INSERT statement for TWO TABLES at time with INNER JOIN
- Delete from same table using inner join seems to be failing (both records removed)
- I don't know How to do this query , I only could find the volume of carton 10
- Is there any specific order of execution in SQL query?
- What is the difference between JOIN and INNER JOIN?