Forum Discussion
Create a new table through sql query using the existing table that was loaded via excelsheet
Hello,
I have table A that has 2 values - Email address & Client Status which has been created using an excelsheet.
Now, I want to create another table that uses the values from this table to create another table B which will now have few more columns like Title, Role etc. along with Email address & Client Status using power query.
Earlier I used to create a temp table in MS SQL for table A and would use it in the Query Editor to create table B but when I already have the data of Table A in Power BI, I want to eradicate use of MS SQL.
My query is as follows -
select Email Address, Title, Role, Client Status from Table A, Table B where A.email = B.email
How do I use Table A in the power query?
8 Replies
I believe that what you need to do is merge the tables in Power Query
Hi Paul,
I want to create Table B.
Merge is possible for the tables that are already present.
Sorry, I misunderstood your question.
what is the source for the extra columns? SQL? If so, import and merge.
If not, it sounds to me you are better off creating the whole table in Excel. (Or create another table with the extra columns in Excel and then merge them, if you are only updating the second part). I find it hard to see the benefits of doing this in Power Query
pshetty05 , Missed your last update. Option in edit query
Copy a table and remove column not need and remove duplicates
Select the required column, Right-click , last option add as new query and remove duplicates, convert to tables.
In DAX, you selectcoulmns, summarize, summarizecolumns
