Even filtering on some other specific value leaves the row with null as well as rows with that specific value.Ĭan anyone else replicate this? Planning to send a frown. Optionally, you can skip this step and use the hardcoded path of the file later in the. To establish the connection, create a new variable named ExcelFilePath and initialize it with the Excel file path. The problem is that step 3 appears to have no effect: the row with null cannot be filtered out. Before running an SQL query, you have to open a connection with the Excel file you want to access. Then try to filter out the row with null in the Product column using Table.SelectRows.In the resulting table, as expected, there is a row with null in the Product column (corresponding to rows from Sales with Products that don't appear in the Product table).(in my example I have joined Products & Sales tables, joined on Product column). Merge two tables using Table.NestedJoin with JoinKind.RightOuter.I have encountered a possible bug when I follow these steps in Power Query:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |