Joining two files without a common value

[SnapWizard]

I want to join two files based on a field of file 1 containing the value of a field in file 2. What would be the best way to do this?
e.g.
File 1: $district_name='ABC School District". File 2: $district: ‘ABC’.
So if $district_name.contains($district). I want to set $new_district in File 1 to $district

[bojanvelevski]

HI @SnapWizard ,

I’m not sure how the incoming data and the output format would be, but for starters you can check this pipeline. If not a solution, it may give you some ideas.

Exercise_2021_08_23.slp (7.0 KB)

Regards,
Bojan