Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Join multiple different tables

Hello, I have loaded 6 tables in power bi. Combination of date and email would act as unique identifier for each table. I want to merge all 6 tables based on date and email to create sort of one sup...
Need Help
parry2k's avatar
parry2k
Super User
7 years ago

Anonymous you can use append features in power query to make super table. There are many blog on how to combine multiple files from a folder. Hope this video help.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

parry2k  Thanks for the reply. I think I didn't put my question properly. I am looking for something like merge query (want to join 6 tables in one go).

Isn't append is for putting row data one below other? I want to column merge them. I have read somewhere that you can do that in one go in sql, don't know how to do that in power bi. I tried joining them one by one using full outer join but that seems lees intuitive.

Updating later on is no problem at the moment as I will manually update them in excel and refresh it in power bi. I hope that won't be problem.

I am new to power bi.

Thanks

Jitendra