Options

[SOLVED] Get all possible combinatios from the values from different tables

bzavalabzavala Member Posts: 19 Contributor II
edited November 2018 in Help
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.

Answers

  • Options
    MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,517 RM Data Scientist
    Hi,

    i think cartesian product is what you search for. But be careful with many attributes.

    ~Martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • Options
    BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 955 Unicorn
    Many attributes is less of a problem (they are just added). Many examples is (their numbers are multiplicated).
  • Options
    bzavalabzavala Member Posts: 19 Contributor II
    Thanks you very much
Sign In or Register to comment.