+ Reply to Thread
Results 1 to 3 of 3

Power Query , Combine Columns how combiner works

Hybrid View

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

    Power Query , Combine Columns how combiner works

    Hi,
    Can someone help with this if I have two columns to combine and the is an empty cell in one column when combine
    using Text.cobine ignores the delimiter and just returns the one value , but a combiner adds the delimterter to the singel value,

     iTable.CombineColumns(  Source, { "ColA", "ColB"},   each Text.Combine(_, "-") ,"N") 
    
    and 
    
    able.CombineColumns( Source, { "ColA", "ColB"}, each Combiner.CombineTextByDelimiter("-")  (_)  , "N")

    so Question 1) why does a = just text and b = delimiter plus text when there is an empty cell I thought it might be to do with quote style but only guessing, and 2)
    can a splitter. be made to behave like text.combine? I have attached the example of the two
    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
    22,056

    Re: Power Query , Combine Columns how combiner works

    Text.Combine ignores nulls, whereas the Combiner doesn't. Just the way they are written.

    For a splitter you can just remove nulls afterwards if you want.
    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
    804

    Re: Power Query , Combine Columns how combiner works

    Thanks,

    RD

+ 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. [SOLVED] Combine .csv files with Power Query
    By FreakyOctopus in forum Excel General
    Replies: 21
    Last Post: 07-02-2024, 04:22 PM
  2. [SOLVED] [Power Query] How to filter 0 from two columns in power query editor in one step?
    By daliye in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-16-2023, 09:44 PM
  3. Combine three datasets in Power Query
    By MightyMike in forum Excel General
    Replies: 3
    Last Post: 05-09-2022, 09:52 AM
  4. Replies: 3
    Last Post: 10-20-2020, 07:45 PM
  5. [SOLVED] Power Query Combine
    By kabseeker in forum Excel General
    Replies: 2
    Last Post: 05-05-2020, 10:12 AM
  6. [SOLVED] I do not have a combine option - Power Query
    By callumlmcgrath in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-08-2019, 06:24 AM
  7. [SOLVED] Power Query - One works the other does not (replace with if statement) - Why?
    By learning new things in forum Excel General
    Replies: 13
    Last Post: 08-20-2018, 09:46 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