I have a table and I'd like to remove all the brackets and contents for a select range in my power query table. I could split each column and then delete the columns with the bracketed data. I'm looking for a quicker cleaner way if one exits.

Hi - wondering if anyone else has encountered this. I use Power Query with a connection to a SQL Server database. We recently updated to SQL Server 2016 and updated our database and since then, when I use Power Query, there seem to be a few relationships missing in the source. Previously each table in the source had some columns at the end that were related and I could expand them to get rows from that table. It all worked great and saved me having to create those relationships. With the new setup, some of the relationships are there, but some of them seem to be missing. When I expand those tables I get what looks like a cross-join and invalid lookups.

Has anyone else encountered this? I don’t really have access to the SQL Server and I ran this by our IT admin and he had no idea what to do.

I'm having a little trouble with the correct syntax to add a new column (not replace existing) which is merged from a dynamic list of column names.

The attached shows the expected result using the built in function 'Add Column > Merge Columns' (see query "tData_AddMergedColumn", which I'd like to replicate but make dynamic by merging from a list of column names. If I just pass the list through then the column names are merged instead of the field values (see "tData_AddMergeDynamicColumn"). I guess I need another 'each' or Record.FieldValue reference, but I keep getting errors.

I want to generate a list like { "member_1", "member_2", ... "member_n"} where "n" is stored in a variable
Is there an easy way without generating a list of numbers "1 to n", converting to table and ... and merging with another table containing "member_" ?

I'm screen-scrapping a bunch of data, and I often get an error for some reason. Is there any way to save the results obtained up to the error? This would allow me to download the data in chunks, rather than forcing me to find a way to make everything work before any results are returned.

]]>Charleyhttps://www.excelguru.ca/forums/showthread.php?9633-Can-we-save-a-partially-completed-queryPower Query – combine two tables and show A L L unique keyshttps://www.excelguru.ca/forums/showthread.php?9632-Power-Query-–-combine-two-tables-and-show-A-L-L-unique-keys&goto=newpost
Fri, 30 Nov 2018 15:16:47 GMTHello community!
Long time since I got in touch, but here I am again. Thank you again for getting me started with Power Query earlier. This...

Hello community!

Long time since I got in touch, but here I am again. Thank you again for getting me started with Power Query earlier. This question may seem basic but I can´t make it work. The function is applicable in many situations, but I give the present case to solve.

I have accounting data from year 2017 and 2018 and need to combine 12 columns of 2017 and 12 columns of 2018, matching the different accounts on the same rows. (We are “cleaning up” in the accounting, by both excluding old, now useless accounting numbers, as well as adding new, relevant ones. Our accounting software can only present one fiscal year at a time, thus 2017 or 2018.)
Example:Year 20173010 sales Sweden3011 special sales to Adam, Sverige (this one is missing in 2018)3510 Invoiced costs5010 Rent…

Therefore, I have tried to export 2017 and 2018 separately, and to combine them through the Power Query Editor. I believe it is called to “Merge questions” (unfortunately I have a Swedish editition of Office 365).

In the drow-down, I choose “Complete, all rows from both”. But no matter how I try, I end up either with all data from 2017, showing mapping data from 2018, or the other way around. We need both 3011 and 3520 in the example above.How can this be solved? Great big thank you in advance! /Spangamamman

Attached here you'll find the sample data for Power Query Challenge 4, as posted on the Excelguru blog. (Full details of the challenge and desired outputs are listed in the blog post.)

In order to submit your solution, please just reply to this thread, attach your workbook (use the Advanced Reply), and give us a brief description of how you approached the issue. (Did you use a custom function, make multiple queries, create parameters, drive it all through the user interface, etc...?)

We'd love to encourage discussion about the challenge and solutions provided. Please feel free to ask questions and give praise to the approaches provided by others. :)