Hello, I have table like this IDJoinKeySome other detail2ICT3foo3ICT3foo4ILM1foo5ILM2foo I need to join it with this table IDJoinKeyValue1ICT3202ILM1103ILM2304ICT250 What is the actual result I get: IDJoinKeySome other detailValue2ICT3foo204ILM1foo105ILM2foo30 The result I need: IDJoinkeySome other detailValue2ICT3foo203ICT3foo204ILM1foo105ILM2foo30 So basically my Join joins only first occurence of the JoinKey but not the others. I use regular Join tool with Join by Specific Fields configuration by JoinKey. How can I solve this please?

Join on every row, not the first only

Hello, I have table like this

ID	JoinKey	Some other detail
2	ICT3	foo
3	ICT3	foo
4	ILM1	foo
5	ILM2	foo

I need to join it with this table

ID	JoinKey	Value
1	ICT3	20
2	ILM1	10
3	ILM2	30
4	ICT2	50

What is the actual result I get:

ID	JoinKey	Some other detail	Value
2	ICT3	foo	20
4	ILM1	foo	10
5	ILM2	foo	30

The result I need:

ID	Joinkey	Some other detail	Value
2	ICT3	foo	20
3	ICT3	foo	20
4	ILM1	foo	10
5	ILM2	foo	30

So basically my Join joins only first occurence of the JoinKey but not the others. I use regular Join tool with Join by Specific Fields configuration by JoinKey.

How can I solve this please?

Join

Accepted answers

romanzdk

Thank you all very much. Problem was I had in first table some keys like "ICt3" and in the second one were all "ICT3" so the case was the case.

Thank you all again.

All comments

Thableaus

Hi @romanzdk

It seems you're using "ID" as a Key Field, and for your case, you should just use the "JoinKey" field to get the expected results.

Check your Key Fields in the Join tool again, that might be the problem.

Cheers,

romanzdk

I use JoinKey for the joining tool

TonyA

I copied your data and did the join. I got the result you said you were expecting. I'm attaching my workflow. I suggest you compare it to yours and see what's different.

Join Example.yxmd

romanzdk

Thank you all very much. Problem was I had in first table some keys like "ICt3" and in the second one were all "ICT3" so the case was the case.

Thank you all again.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703