Match data

[Nandy]

Hello,

I have a dataset that contains Input 1 & Input 2 as below,

Input 1

Field1

this_AAA_data_is_direct_and_time_huge

this_AAA_data_is_huge_and_time_effective

this_data_is_high_and_time_effective

Input 2
Field1	Field2
time_huge_data	xxx
time_high_data	yyy
time_huge_direct	zzz

Need to compare these & map ,to get the output as below . The positions of the string vary , if input 1 contains input 2 , i need field2 against it.

Field1	Field1	Field2
this_AAA_data_is_direct_and_time_huge	time_huge_direct	zzz
this_AAA_data_is_huge_and_time_effective	time_huge_data	xxx
this_data_is_high_and_time_effective	time_high_data	yyy

[Nandy]

Hi all,

thanks for your ideas, one of my friend suggested the below & it worked, Sharing with you all

Attaching the flow,

in this case the record 1 had two matches but that's because of the way my input is defined.