+ Reply to Thread
Results 1 to 16 of 16

Merge multiple tables

Hybrid View

  1. #1
    Forum Expert
    Join Date
    12-09-2014
    Location
    Trakai, Lithuania
    MS-Off Ver
    2016
    Posts
    1,405

    Re: Merge multiple tables

    Power Query (https://www.youtube.com/watch?v=AhaNv3Iis3c)
    let
        Source = Folder.Files("C:\Users\seven\Documents\Documents\CC"),
        #"Added Custom1" = Table.AddColumn(Source, "Custom.1", each getData([Folder Path]&[Name])),
        #"Removed Columns" = Table.RemoveColumns(#"Added Custom1",{"Content", "Date accessed", "Date modified", "Date created", "Attributes", "Folder Path", "Extension"}),
        #"Replaced Value" = Table.ReplaceValue(#"Removed Columns",".csv","",Replacer.ReplaceText,{"Name"}),
        #"Expanded Custom.1" = Table.ExpandTableColumn(#"Replaced Value", "Custom.1", {"Belegdatum", "Eingangstag", "Verwendungszweck", "Fremdwährung", "Betrag", "Kurs", "Betrag_1", "Währung"}, {"Belegdatum", "Eingangstag", "Verwendungszweck", "Fremdwährung", "Betrag", "Kurs", "Betrag_1", "Währung"})
    in
        #"Expanded Custom.1"
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    12-05-2022
    Location
    Berlin
    MS-Off Ver
    365
    Posts
    12

    Re: Merge multiple tables

    Thank you, Czeslaw. I will look into this. Obviously, it does not help that I do not understand Russian to understand the video (if the video is Russian...) but I think I can get it together

+ 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] Merge multiple tables into one
    By JackBauer in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-12-2017, 10:49 AM
  2. How to merge multiple tables into 1 master table?
    By Ashley1016 in forum Excel General
    Replies: 11
    Last Post: 04-14-2017, 05:51 AM
  3. Help with Pivot Tables to merge two tables
    By scrawl.to.me in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-26-2015, 06:01 AM
  4. Merge multiple tables in one table
    By chiidzzz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-28-2013, 05:16 PM
  5. Replies: 3
    Last Post: 12-06-2012, 10:51 AM
  6. merge multiple tables
    By magnus101 in forum Excel General
    Replies: 2
    Last Post: 10-31-2012, 12:36 PM
  7. [SOLVED] HOW TO MERGE TWO TABLES
    By Bill Vogel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 11:05 AM

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