Forum Discussion
get all items to every customer
ok, I'm pretty sure, there is a smarter way to solve this, but I found a workaround:
I added a column in each table like:
Customer No Dummy
1110001 a
1110002 a
1110003 a
Item No Dummy
5001 a
5002 a
5003 a
and then i was able to merge both tables.
Community ChampionPlease try this... Using "New Table" option as below...
Thanks, that would work perfectly if i didn't need it in the Query editor.
I need to merge some of that information into anohter table.
- PattemManohar
Anonymous Could you please elaborate bit more detail, what you want to achieve finally as output.
Any related sample input data and expected output will be really helpful.
it is actually pretty complicated. We ve got a new Software and I have to check if all customers have the same conditions.
So i use Power Bi to recreate the price setting for both programms.
In the end i want a list of customers and Items where Program A gets another Price than Program B.
In Program A every customer has a Pricelist (there are about 10 different pricelists). But most pricelists do not include all items.
If a customer buys a product that is not included in his pricelist there is a fallback solution and he gets the price from pricelist A.
I already have a Table with all Customers and Items (corresponding to their Pricelist) But I didn't have the Items not included in the associated Pricelist.
What I'll do now is to create the above mentioned list where every customer and every Article (and every fallback price) are included. I merge it with the table I have already got and I create a column where: If there is no price for an item regarding the accociated pricelist it takes the price from the fallback.
After that I just have to make a List with all Customers, Articles and the new Column and Program A is rebulit.
ok, I'm pretty sure, there is a smarter way to solve this, but I found a workaround:
I added a column in each table like:
Customer No Dummy
1110001 a
1110002 a
1110003 a
Item No Dummy
5001 a
5002 a
5003 a
and then i was able to merge both tables.