Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.

Join with multiple fields

SouravKayal
8 - Asteroid

Hi Team,

 

So i have a big data set and initially i was doing two joins based on different criteria's.

 

Join 1:

 

Table 1                          join 

ID  name $                  ID Date

1     xyz   50                 1   20/1

 

Join on ID

 

Join 2:

 

Table 2                                         join table

 

UID  Owner  SID  LID              UID SID LID Record ID

 

Join on multiple fields: UID, OWNER SID , LID.

 

Now as the data set were big I did all the transformations and did a union of both data sets and tried to join in multiple fields like: ID, UID, OWNER SID , LID. but join returns me 0 records

4 REPLIES 4
echuong1
Alteryx Alumni (Retired)

Are each of the join fields separate (ex: join by UID OR join by Owner OR join by SID) or should the output use all of the fields for the join critieria?

 

If the latter, add all of the fields in the same join by adding additional drop downs.

 

Hope this helps!

 

echuong1_0-1610388082721.png

 

Emil_Kos
17 - Castor
17 - Castor

Hi @SouravKayal,

 

What is the question? 

 

If you want to receive proper help I think the sample of the data would be useful. 

 

If the question is why you don't have any result. Are you 100% sure that you should get one? Having two-step join is a different scenario then one join on bigger amount of columns. 

ak2018
8 - Asteroid

Well, I have a peculiar requirement:

 

Table 1 has a Field, say RecCode that has a value, SAY 234987

 

Now, I have Table 2, that has a field, say RecCodes (note the plural) and can has various values appended interspersed with text and the RecCode, say ABC= 234987 HFS=389756 and so on.

 

I want to pick that RecCode from Table 1 and look if it exists in the RecCodes field in Table 2 and pull that corresponding record from Table 2. Any thoughts?

Luke_C
17 - Castor

Hi @ak2018 

 

Give this a shot:

 

  1. Find and replace to look up the code in table 1 in the table 2 data. If it's found it is set to append a new field with the single RecCode.
  2. Use that appended field to facilitate the join and get the data

Luke_C_0-1647629785823.png

 

 

Labels