Data comparision

[Nandakishore]

Hello,

I have this requirement as mentioned below . 

Data Set1	Dataset2
123443AAAA34444555	CCCCC
w233werr324TTTTT	BBBBB
	AAAA
	TTTT

Each value in Data 2 must be lookedup for the string in Dataset 1 . If there exsists Dataset2 in Dataset1 string then below output need to generated. 

Output
AAAA	123443AAAA34444555
TTTTT	w233werr324TTTTT

Thanks in advance

[nagakavyasri]

@Nandakishore 

[ChrisTX]

Try the Find Replace tool, under the Join palette.

 

 

Chris