As can be noted in both tables I have the LocOrgTrab_CD and Entidade_ID fields, and through them I need to somehow relate these two tables to setornar into one, in the end I wanted to have a table with the following fields:
I can do it without problem using the Add Query feature, however the table information with B table are not matching, for example where has values of other fields in LocOrgTrab_ID field is null, and when I have the field values LocOrgTrab_ID values the other fields are zero, and the LocOrgTrab_ID field is the table key to the future will relate to the fact but trying to make this relationship with fact not the right due to the aforementioned problem.
Ja I Sweetheart create the same LocOrgTrab_ID field in Table A but it is not possible, any suggestions of what I can do? there is a way of doing an INNER JOIN joining the two tables to make one and not bring information void?
Have you tried using the "Merge Queries" feature in Power BI Desktop? The way that works is that you choose columns that are related to each other from each table and merge the two tables together based on those relationships.
I used this feature and made the relationship but that first time are experiencing some errors, the information at the end is not correct, I am investigating why but would have any tips on how to use this function?
If you can provide some context as to what exactly is going wrong, it would be easier to troubleshoot. Please provide examples of what you started out with, what join you used and the resulting table of that join. Also provide, what output you expected. This way we can try and replicate it on our end and see where you may have went wrong, thanks.
My two tables have most of the same headers but different records. When I merge queries, I get the new column at the far right of the table. The data does not merge whether I choose expand or aggregate. How do I get it to merge?