power query

  1. D

    Restrict Number of Keywords per Key

    Hi, I have the following table and my goal is to have to restrict the number of keywords per key to 3. For every key containing more than 3 keywords, I want to delete every keyword after the third one...
  2. P

    Adding Relationship tables from Salesforce through Power Query

    I don't see a lot from Salesforce/Power Query questions here but I have the following M in Power Query to pull data in from Salesforce custom table 'SR__c'. The table has a nested relationship table named 'RO__r' as placed in bold below. When I try to expand the relationship table ('RO__r'), it...
  3. smozgur

    Parent & Child Relationship Between Sources in Power Query

    As long as there are matching fields in the source tables, we can join the associated queries (one-to-one, one-to-many, etc.) by using the Merge feature. We are going to use the following sample source tables to demonstrate parent & child merging. These tables have a parent-child relationship...
  4. J

    Using VBA Power Query to import PDF tables

    I have a PDF that has three pages - each page has a header and detail and the last page has an additional footer. I'd like to use Power Query to import the PDF tables into Excel I ran the File ->Get data ->From File -> From PDF and it came back with 6 tables and three pages I'd like to import...
  5. R

    Get Position of First Text Char in Number & Text mixed String Power Query

    1. How to get the positions of the first text char in a mixed string? AB7Files NamesOutput (position of first text char)81112. Orders692451 2 . Refunds910#784&@ . Cancellation9B8B8=SEARCH("O",A8)-1B9B9=SEARCH("R",A9)-1B10B10=SEARCH("C",A10)-1 2. How to use these splitter functions with...
  6. J

    Linked Files - How to update both without Sharing Violation

    I have 2 workbooks that I have linked together. One takes 2 massive csv files and makes them show ready for the second file. I am currently working on cleaning these files up to make them quicker and cleaner, plus merging in some more from other files. However, when needing to make changes in...
  7. R

    Power Query Split Rows Bases on a Condition

    I want to split each row in Order Table into 2 separate rows where the quantity does not match the quantity given in Refund Table and further mark them as "Partial Order" and "Partial Return". With the help of the unitary method, I want to split their values as well. (refer to the result table)...
  8. D

    Delete duplicates per key in a column

    Hey everyone, I posted this earlier as follow-up in a different thread, but I thought it would be wiser to open a new one since its a different issue than the original one. I want to delete duplicates per key in this table...
  9. D

    How to create a table for baseline sales?

    Hello everyone, long time no post! I have a situation, which I would think can be solved rather simply, but I can't figure out a way to do it. I have several POS systems and how much they are able to sell. We also have the knowledge of how much volume we do every weekday, every month that...
  10. TheMacroNoob

    Pivot Column into "Actual" and "Budget" values

    Hello all, See table for example data set. I have transformed 2 files, one "Actual", one "Budget", and they are appended. How do I unpivot the "Source.Name" column in a way where I have two columns, "Actual" and "Budget", their corresponding value for GL Code, GL Name, and Cost Center? I will...
  11. J

    Can the list of Tables presented by a Function be filtered?

    I have a PQ Function that starts like this: (FredURL as table) => let SrcURL = FredURL{0}[Column1], The function works great, but when invoked, a list of ALL tables in the Workbook is presented. Is there a way to filter that list so that only table names that start with "url" are...
  12. iosiflupis

    Merging/Combining different columns from different worksheets

    I have five (5) different files that have .csv files in them. The five folders of information have five different columnar layouts. Is there a tool/trick/workaround in Power Query or Power BI where I can pull the different columns into one worksheet/table that has all the columns that I would...
  13. S

    VBA or Slicer / Power Query - Is it possible to select pivot table fields (column headers)

    I am working with a price list and would like to select pivot table fields (column headers) based on the price level (PL) selected which is also a column headers. The price level is indicated by Z0 and Z1. This particular column header can be used or not as part of the solution because there is...
  14. J

    Template to create a URL for Power Query to make a API Call for Federal Reserve Economic Data (FRED)

    There is an Excel Add-in that makes retrieving Economic Data from the Federal Reserve (simply called FRED Data) easy. However, there are inherent problems it presents. You put the CODE of the data series you want in row 1, and optionally add Data Manipulations (such as retrieving the change from...
  15. L

    Power BI - unable to fetch data using API

    Greetings Everyone, As it is my first post I would like to thank you for opportunity to join this community. My name is Piotr and recently I have been asked to download data from transparency platform using API and Power Query. I have never seen or used Power Query or API therefore I kindly...
  16. S

    Eror Pivot Coloumn on Power Query

    Hello, Pivot coloumn on Power Query excel, but i have problem eror with description like this "There were too many elements in the enumeration to complete the operation". How to resolve errors on pivot coloumn? Thanks
  17. D

    Use of the if function in the power query.

    Hello everyone I can easily separate quarterly balance sheets by quarter in excel. Is it possible to do this in a power query? Please help if possible. https://dosya.co/vd1c2pxgezhz/_____Finansal_Tablolar.xlsm.html
  18. iosiflupis

    How to move column to row

    Hello, I have a table with three columns. Date, Location, and Count. What I would like to do is keep the Date column as it is, make the Location column into three separate columns (Garage, Preferred, and Outdoor) and then populate the rows with the counts that correspond to the date by...
  19. L

    Power Query: Cleaning Repeating Delimiters

    Hi there. I've been using PowerQuery to collapse a flat file into combined, multi-value cells with delimiters. The inconsistent nature of the raw data results in repeating delimiters / spaces, like so: ; ; Smith, Judy; Carson, Kevin; ; Levy, Kevin; Bloom, Judy; ; ; ; Nicholas; ; ; I'd...
  20. L

    Power Query: Removing duplicate values in Multi-Value Cells

    Hi there. Long-time Excel user and dabbler in VBA and Power Query. I've got a variation on a problem I posted a few years ago in this thread. There, folks helped me use PowerQuery to collapse data, combining multiple rows into single, multi-value cells while removing duplicates. The wrinkle...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top