Forum Discussion
Power Pivot: Need help population information from one row to another
So after thinking about the second part of your comment once more I came up with the following solution. Please let me know whether you think it's correct or not:
I merged the two queries to the two data bases (company A and company B) and did an "Inner join" via GTIN (so I kept only the corresponding/matching rows). Then I kept the columns "GTIN" and both article numbers and removed the rest. Then I removed duplicates on the column "article number A" in order to have a unique identifier that I can connect to my main table. So via this table and the established connection via "article number A" I am now able to do "=related('tableInnerJoinofTable1andTable2'[article number B])" and now I have the article number next to the pallets as well.
Community ChampionNot sure I understand totally. How is the system supposed to know that the missing GTIN for item 3 Article A 10000123 is the same and should relate to 55500001 with 1,000 units. I get the 1,000 unit part, but what makes article b and article A relate.
What if you created your own table of all GTIN codes and article numbers and populated them with Power Query where they were blank from the source? I always prefer to create tables like this vs doing some smart logic that breaks down later.
If you can explain the first part for me, or consider the second, let me know and I'll see where I can help.
So after thinking about the second part of your comment once more I came up with the following solution. Please let me know whether you think it's correct or not:
I merged the two queries to the two data bases (company A and company B) and did an "Inner join" via GTIN (so I kept only the corresponding/matching rows). Then I kept the columns "GTIN" and both article numbers and removed the rest. Then I removed duplicates on the column "article number A" in order to have a unique identifier that I can connect to my main table. So via this table and the established connection via "article number A" I am now able to do "=related('tableInnerJoinofTable1andTable2'[article number B])" and now I have the article number next to the pallets as well.