I am building a query to compare two tables. The tables will always have the same columns/column names. The tables are merged and expanded such that all column names are suffixed with “old” or “new” (in order to rearrange them alphabetically) depending on which table they came from.

I am building a query to compare two tables. The tables will always have the same columns/column names. The tables are merged and expanded such that all column names are suffixed with “old” or “new” (in order to rearrange them alphabetically) depending on which table they came from.

Closed 16 mins ago.

Closed 16 mins ago.

Closed 16 mins ago.

I have one table with several rows (24), I need to split this table into 24 pages – each row = own page.

I am trying to get a helper value that changes if certain values change from the prior row. For instance, if the Site, Room or Cubicle value changes from the previous row, I want the helper value to increase by one. I am utilizing this method to separate specific data by row fill color utilizing conditional formatting. In a general workbook I can reference cells so a simple IF statement such as the following works.

I have two tables (table1 and table2).
I want to perform an inner merge query with both tables.

I’ve a table with some columns containing JSON which I need to convert from text to proper JSON.

I’ve done a number of API pulls through power query and generally they’ve been relatively easy, however the application I’m trying to pull from doesn’t make it easy when there’s more than 5k of records. I can either cycle round and pull each new page based on a value passed as part of the JSON or use a different API, which involves posting a request to the API for the particular report to create a dataset, then receiving a dataset ID and using that to then pull the records from the report.