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!
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.
Thanks, @AkimasaKajitani! This solved my use case, too 😁