The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
[SOLVED] Get all possible combinatios from the values from different tables
Contributor II
Hi! I need your help to solve the next problem:
I have a table with dates and a table with SKU´s
Table 1: Date-hour table
Att1 Att2
01/03/2013 0:00
02/03/2013 1:00
02/03/2013 3:00
Table 2: Sku´s table
Att1
1
2
I need to get all possible combinatios between that tables. I want to get
Att1 Att2 Att 3
01/03/2013 0:00 1
02/03/2013 1:00 1
02/03/2013 3:00 1
01/03/2013 0:00 2
02/03/2013 1:00 2
02/03/2013 3:00 2
How can I do that? Thanks you in advance.
I have a table with dates and a table with SKU´s
Table 1: Date-hour table
Att1 Att2
01/03/2013 0:00
02/03/2013 1:00
02/03/2013 3:00
Table 2: Sku´s table
Att1
1
2
I need to get all possible combinatios between that tables. I want to get
Att1 Att2 Att 3
01/03/2013 0:00 1
02/03/2013 1:00 1
02/03/2013 3:00 1
01/03/2013 0:00 2
02/03/2013 1:00 2
02/03/2013 3:00 2
How can I do that? Thanks you in advance.
0
Answers
i think cartesian product is what you search for. But be careful with many attributes.
~Martin
Dortmund, Germany