Hello guys,
Please for your help..
I have two tables...
TableA
Product No. Description
001 A
0007 B
014 C
TableB
ProductDetNo. Description
001-241 A
004 N
0007-9 B
0145-972 Z
The final table with a join between the above two tables,i would like to be :
TableC
Product No. ProductDetNo Description
001 001-241 A
0007 0007-9 B
So the join is something like Product No contains ProductDetNo..
Thank you for your help..
Solved! Go to Solution.
Hi @Anastasio_Theohari ,
The Find and Replace tool will give you exactly what you're looking for. I've joined the sets using this tool to tell me when one is a subset of the other. Then you simply filter out the ones that are not:
I've attached the workflow for you.
Hope this helps.
M.
Hi @Anastasio_Theohari ,
You can do that using a Find & Replace tool, looking for values contained in Table A Product No. column in the Table B Poduct Det No. column.
You can configure the tool to only return you exact matches
so 014 will not match with 0145 but 0007-9 will match with 0007.
Hope that helps,
Angelos