Forum Discussion

Boycie92's avatar
Boycie92
Resolver I
8 years ago

Joining Tables

Hi

I am wondering if someone can help,

 

I have a table that has Product ID 1 and Product ID 2 (they both link to the same product)

 

I have a also have a Date Table.

 

I want to be able to merge them together so that every date within the date table has Product ID 1 & 2 beside them

Is this possible?

 

Thanks in advance,

 

Boycie92

Need Help
Show and Tell

2 Replies

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    8 years ago

    Boycie92 may i ask what you are trying to achieve exactly?    you could create a  conditional calculated ID column and give ita  new id where its product 1 or 2, but it would be helpful to know what  you want to do?

     

    for example

     

     

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    8 years ago

    Hi Boycie92,

     

    Could you post your table structures with some sample/mock data, and the expected result against the data? So that we can better assist on this issue. :smileyhappy:

     

    Regards