Combine multiple table to one on Power Query

[Jouworld]

Hello,

I want to combine multiple tables to one on power query and i did it, but i have 48 table that have i title that i want to use as information in a new collumn.

Help me please!

@PowerQuerryGuru 

@PowerQuestion 

[v-jingzhang]

Hi @Jouworld 

What is the data source of all 48 tables? If they are files like Excel, TXT, CSV .etc and stored in the same folder, you can use Folder connector to connect to this folder and combine all files into one query. After combining files, there is a new "Source.Name" column in that combined query. The Source.Name column indicates that from which file every row is getting data. 

Reference:

Folder 

Combine files 

Import all CSV files from a folder with their filenames in Power BI 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[jbwtp]

Hi @Jouworld,

I guess, you are combining files from a folder or sharepoint and got this ugly result.

The way to fix it is to find something like this (this set of queries are created by PQ Editor automatically when you export a quantity of files):

You are interested in the last one which looks like a table and typically would be called "Transsform Sample File".

Open (select) this query and add a step "Use First Row as a header" (you may need to do it a couple of times to push the headers in the headers).

It will automatically apply this to all files being loaded and should sort your issue.

Let me know if this is more complex than this.

Cheers,

John

[KT_Bsmart2gethe]

Hi @Jouworld ,

I am not quite able to link your description to the screenshot.  (i.e. what do you mean by "have 48 table that have i title that i want to use as information in a new column."

What is your desired outcome? Would you be able to mock up one and share it? 

Regards

KT