get all items to every customer

[herbemischung]

Hey,

i've got 2 Tables.

Table A: Customers

--> ist just a list of ervery customer like:

Customer No

1110001

1110002

1110003

and so on

Table B: Items

--> its just al list of all Items the company sells

Item No.

5001

5002

5003

and so on

I want to have a 3rd Table where these two Tables are combined like:

Customer No    Item No

1110001            5001

1110001            5002

1110001            5003

1110002            5001

1110002            5002

1110002            5003

1110003           5001

and so on...

I thougt this is simple, but I am still failing, maybe someone of you might have a clue?

thanks!

[PattemManohar]

Please try this... Using "New Table" option as below...

[herbemischung · Accepted solution]

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. 

[herbemischung]

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]

@herbemischung 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.

[herbemischung]

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.