Merge multiple tables

Power Query with From Folder then add Month Name to each month next Append Queries (not merge) then you can filter or use Pivot Table

Wow, that was quick and almost too easy Thank you already very much!

Even though I was trying to follow each of your steps, I think I achieved my goal already after steps 1 and 2.

What I did was:
Get Data/from file/from folder and then Combine &, Load - and there it was!

But there are two issues:
1. Each CSV File has four lines of general header and one sum row footer. Can I get rid of those using this batch method? I did not see a moment to intervene when using this method.
2. Each CSV File has in row five table headers. I only want those once in the combined file. Any way to do this using the above method?

Last, apologies for not following your description 1:1, but can you elaborate on what you mean by "add Month Name to each month next Append Queries (not merge)"? Not sure where I would be able to execute that.

Thanks again!

I will try to send it tomorrow. It’s late where I am now, and I would need to edit the content a bit, as mentioned it is credit card data Thank you already a lot!

sure, no Top Secret things !

Hi!

Below/attached are two example files. First, I want to eliminate the first four rows and the last row in each file and then have the fifth row interpreted as the header row.
I played around with PowerQuery, now use "Combine & Transform" and understand the Query Settings Section, where I can set the rules.
But not sure where to enter what I want as described above.

Any help is much appreciated.

Thank you!

File No 1: CC_11.csv
File No 2: CC_12.csv

you will need to fix path to the csv file

Originally Posted by Ragazo

This is so wonderful; THANK YOU!
It helped me a lot.

You are welcome

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"

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

Hi all
Since the OP issue resolve so I am going to post my questions please ( I do not want to hijack this post).
I tried your steps but I end up with some problems, here are my questions

1) Step 3 in Power Query, what you have done exactly?

Attachment 808921

2) Step 4 in Power Query, what you have done exactly?

Attachment 808922

3) Step 6, I changed the path in the first step but now it is trying to go to D:\ drive again and I have no way to change that? Any idea how to change the path

Attachment 808923

Thank you very much.

Originally Posted by lastnn30

.

Your attachments are invalid, read big yellow banner at the top of the page
about path: you need to change path to the folder with your files (there is a Browse button)
for the rest post new thread with your problem or Learn Power Query

Ok, thanks for your reply. I will post a new thread. Thanks a lot.

Thank you.