How to combine two tables with asterisk values

Question

Hi All,

I want to join two tables as shown in the attached image but the simple join tool doesn't work. Is there any better way/tool to help me join the tables as desired?

Table1Col AA*B*BD*EF*12**20*

Table 2Col B2021*2022*ABC*ABCD*123*AZC*12021*

Desired output

ColAColBA*ABC*A*ABCD*A*AZC*20*2021*20*2022*20*12021*12*123*

Thanks,

Vinay

Sample.PNG

Athmakuri · Answer

Thank you Felipe,

I tried this solution but I have cases, where Table 1 contains *123 and Table 2 contains *12345*. In this case, it should not match but the workflow you have mentioned is not working in this case as it is joining these values.

Thanks,

Vinay

Athmakuri · Answer

Thank you @ShankerV

I tried this solution but I have cases, where Table 1 contains *123 and Table 2 contains *12345*. In this case, it should not match but the workflow you have mentioned is not working in this case as it is joining these values.

Thanks,

Vinay

Felipe_Ribeir0 · Answer

Hi @Athmakuri

Try this workflow:

append.yxmd