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
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!
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.
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?
Hi @ak2018
Give this a shot: