🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.

Join and Win

Data Prep Studio

Fidencio

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
------------------------------

Find more posts tagged with

English

Monarch

Accepted answers

Rebecca_Cronin

Hi Fidencio,

Sharing links to our Monarch Help Guide:

Join 2 tables - Joining 2 Tables
Creating External Lookup - Creating External Lookup

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
------------------------------
"

All comments

Rebecca_Cronin

Hi Fidencio,

Sharing links to our Monarch Help Guide:

Join 2 tables - Joining 2 Tables
Creating External Lookup - Creating External Lookup

CPorthouse

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:

------------------------------
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

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:

------------------------------
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:

------------------------------
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
------------------------------
"