cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Shaglok
Frequent Visitor

Help managing queries

Hello.

 

I thnk I'm going to get crazy with a, for sure, easy question.

 

I have two queries I need to combine. We manage shops, sells and client surveys, but one of our shop uses a diferent survey system, so the data needs to be joined. We also use a global sale ID number for all the shops. The schema is quite this:

 

Table 1:

Sell ID // Shop // Channel // Survey response // Survey comments // and many other fields that are not in table 2.

 

In table 2 we have the same fields. Sell ID always matches with Table 1 (it's also registered there), Shop is always the city of the shop, it is common in Table 2, but in Table 1 we have another cities, Channel is if the sell was at the shop or online (that info is also in Table 1).

and many other fields, like prize, etc. In the table 2 we have a similar schema, but with less columns.

 

The thing is that Sell ID number can be in both tables (in fact, they are, all their sells are registered with that format). Information of both tables only changes in the survey fields, which is empty in the table 1. I need to choose the Sell ID, for example, and when it matches, pass the information of the Survey columns of the table 2 to the table 1. But only these 2 fields, keeping all the others like they are.

 

I tried to merge with all kind of combinations, and I could get the survey info in the merged query, but in exchange I lose all the other fields. of the table 1.

 

Thanks in advance for your help.

3 REPLIES 3
v-jingzhang
Community Support
Community Support

Hi @Shaglok 

 

Did you try Merge queries feature? In the table 1, click Merge queries, then merge the table 2 to the table 1. You can select one or multiple columns as matching columns. This will not lose other fields of the table 1. 

 

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

Yes, thank you very much. I had been touching this, but as I am still very new, I was doing it bad. 🙂

 

Thanks!!

edhans
Super User
Super User

How to get good help fast. Help us help you.

How To Ask A Technical Question If you Really Want An Answer

How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.

Top Solution Authors
Top Kudoed Authors