Data Prep Studio

Fidencio
Fidencio New Altair Community Member
edited March 2019 in Community Q&A
How to join 3 tables or a look up to one of the tables after I join 2 of them.

------------------------------
Fidencio Chavez
Senior Billing Associate
Cu Cooperative Systems
Rancho Cucamonga CA
(909) 786-3452
------------------------------
Tagged:

Best Answer

  • Rebecca_Cronin
    Rebecca_Cronin
    Altair Employee
    edited March 2019 Answer ✓
    Hi Fidencio, 

    Sharing links to our Monarch Help Guide: There is currently not a way to join 3 tables at once. You will have to do 2 tables then join the 3rd.  I am hoping other Monarch Experts might have other tips to share. 

    Rebecca

    ------------------------------
    Datawatch Corp
    Content Specialist
    Datawatch Corporation
    Bedford MA
    (978) 275-8203
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 03-07-2019 07:07 PM
    From: Fidencio Chavez
    Subject: Data Prep Studio

    How to join 3 tables or a look up to one of the tables after I join 2 of them.

    ------------------------------
    Fidencio Chavez
    Senior Billing Associate
    Cu Cooperative Systems
    Rancho Cucamonga CA
    (909) 786-3452
    ------------------------------
    "

Answers

  • Rebecca_Cronin
    Rebecca_Cronin
    Altair Employee
    edited March 2019 Answer ✓
    Hi Fidencio, 

    Sharing links to our Monarch Help Guide: There is currently not a way to join 3 tables at once. You will have to do 2 tables then join the 3rd.  I am hoping other Monarch Experts might have other tips to share. 

    Rebecca

    ------------------------------
    Datawatch Corp
    Content Specialist
    Datawatch Corporation
    Bedford MA
    (978) 275-8203
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 03-07-2019 07:07 PM
    From: Fidencio Chavez
    Subject: Data Prep Studio

    How to join 3 tables or a look up to one of the tables after I join 2 of them.

    ------------------------------
    Fidencio Chavez
    Senior Billing Associate
    Cu Cooperative Systems
    Rancho Cucamonga CA
    (909) 786-3452
    ------------------------------
    "
  • CPorthouse
    CPorthouse
    Altair Employee
    edited March 2019
    You cannot join more than 2 tables in the same join operation.  In order to join 3 tables, you will need to join 2 tables first and then join the 3rd table to that result:
    join 2 tables
    Join 3rd table


    ------------------------------
    Chris Porthouse
    Senior Implementation & Integration Engineer
    Datawatch Corporation
    Chelmsford MA
    (978) 275-8381
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 03-07-2019 07:07 PM
    From: Fidencio Chavez
    Subject: Data Prep Studio

    How to join 3 tables or a look up to one of the tables after I join 2 of them.

    ------------------------------
    Fidencio Chavez
    Senior Billing Associate
    Cu Cooperative Systems
    Rancho Cucamonga CA
    (909) 786-3452
    ------------------------------
    "
  • Fidencio
    Fidencio New Altair Community Member
    edited March 2019
    Chris Porthouse said:

    You cannot join more than 2 tables in the same join operation.  In order to join 3 tables, you will need to join 2 tables first and then join the 3rd table to that result:
    join 2 tables
    Join 3rd table


    ------------------------------
    Chris Porthouse
    Senior Implementation & Integration Engineer
    Datawatch Corporation
    Chelmsford MA
    (978) 275-8381
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 03-07-2019 07:07 PM
    From: Fidencio Chavez
    Subject: Data Prep Studio

    How to join 3 tables or a look up to one of the tables after I join 2 of them.

    ------------------------------
    Fidencio Chavez
    Senior Billing Associate
    Cu Cooperative Systems
    Rancho Cucamonga CA
    (909) 786-3452
    ------------------------------
    "

    Yes Thanks.  I kept playing around with it and did it that way and I also learned how to Append. 

    Thanks for your response.

    ------------------------------
    Fidencio Chavez
    Senior Billing Associate
    Cu Cooperative Systems
    Rancho Cucamonga CA
    (909) 786-3452
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 03-12-2019 04:48 PM
    From: Chris Porthouse
    Subject: Data Prep Studio

    You cannot join more than 2 tables in the same join operation.  In order to join 3 tables, you will need to join 2 tables first and then join the 3rd table to that result:
    join 2 tables
    Join 3rd table


    ------------------------------
    Chris Porthouse
    Senior Implementation & Integration Engineer
    Datawatch Corporation
    Chelmsford MA
    (978) 275-8381
    ------------------------------

    Original Message:
    Sent: 03-07-2019 07:07 PM
    From: Fidencio Chavez
    Subject: Data Prep Studio

    How to join 3 tables or a look up to one of the tables after I join 2 of them.

    ------------------------------
    Fidencio Chavez
    Senior Billing Associate
    Cu Cooperative Systems
    Rancho Cucamonga CA
    (909) 786-3452
    ------------------------------
    "

Categories