Joining two lists

Question

Joining two lists

bpaul 90357

Valued Member

Points: 58
More actions
May 15, 2017 at 8:31 am

#402059

I have a list of Store Locations and an Inventory List. Example below
Store List
Store 1
Store 2
Store 3
Inventory List
Part 1
Part 2
Part 3
What I need would look like below
Store 1 Part 1
Store 1 Part 2
Store 1 Part 3
Store 2 Part 1
Store 2 Part 2
Store 2 Part 3
Store 3 Part 1
Store 3 Part 2
Store 3 Part 3
Is there a way to code this or do I need to do it manually?

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

debasis.yours Hall of Fame Points: 3569 More actions · Answer 1

bpaul 90357 - Monday, May 15, 2017 8:31 AM
I have a list of Store Locations and an Inventory List. Example below
Store List
Store 1
Store 2
Store 3
Inventory List
Part 1
Part 2
Part 3
What I need would look like below
Store 1 Part 1
Store 1 Part 2
Store 1 Part 3
Store 2 Part 1
Store 2 Part 2
Store 2 Part 3
Store 3 Part 1
Store 3 Part 2
Store 3 Part 3
Is there a way to code this or do I need to do it manually?

Hi,

You can achieve this by CROSS JOIN between the two lists.

Thanks.