How to iteratively join

[Aliceyyy98]

Hi,

I would like to join in Dataset B to Dataset A, the two datasets have common columns 1,2,3,4,5,6. However, I would like to:

1. Join by 1,2,3,4,5,6

2. For the unjoined, join by 1,2,3,4,5

3. For the unjoined, join by 1,2,3,4

.........

6. For the unjoined, join by 1

Is there a way to do this efficiently without having to add in 6 join tools to the workflow?

Thank you!

[AkimasaKajitani]

Hi @Aliceyyy98 

The most simple way is to add the 6 Join tools.

But it is able to use Batch macro and to need to rewrite the inner XML of Join tool.

I don't recommend to do because it is too complex.

However I tried it. Please refer the sample workflow. I think it will work well.

[clmc9601]

Thanks, @AkimasaKajitani! This solved my use case, too 😁

[AkimasaKajitani]

Hi @clmc9601 ,

I'm glad I could help!