+ Reply to Thread
Results 1 to 3 of 3

Power query Merge and access column of table

  1. #1
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    758

    Power query Merge and access column of table

    Hi, if I have merge tables as new and then rather than the entire table I only want particular column / s , is there a way ?

    so if if start with
    Please Login or Register  to view this content.
    i could then ;
    Please Login or Register  to view this content.
    but is there another way, I've included a couple of different approaches, to show what I was aiming for ,

    Queries 'salesitem' salescustomer,

    just interested to see if I can get at table columns withing merge. I have a couple of other questions but one at a time.

    Richard.
    Attached Files Attached Files

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,897

    Re: Power query Merge and access column of table

    Quote Originally Posted by Dicken View Post
    just interested to see if I can get at table columns withing merge. I have a couple of other questions but one at a time.
    No. You can only manipulate the resulting table.
    Everyone who confuses correlation and causation ends up dead.

  3. #3
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    758

    Re: Power query Merge and access column of table

    Thanks, at least I can stop trying to do what can't be done.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 03-01-2024, 03:59 AM
  2. [SOLVED] Power Query- Merge column missing
    By bananarchy in forum Excel General
    Replies: 1
    Last Post: 05-11-2023, 05:04 PM
  3. [SOLVED] Power Query merge with lookup table
    By amitdi in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-08-2023, 12:07 AM
  4. Merge Table with Power Query. Primary Key with Duplicate values
    By fkarim74 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-03-2022, 02:52 PM
  5. [SOLVED] merge table into power query and keep greater date
    By Undo in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 09-18-2021, 09:36 AM
  6. Power query merge column
    By Eric Tsang in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-17-2020, 09:08 AM
  7. Replies: 9
    Last Post: 11-29-2017, 01:32 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1