Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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.
Regards
@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
Proud to be a Super User!