This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Joining two files without a common value

SnapWizard
New Contributor III

‎08-23-2021 08:28 AM

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

0 Kudos
1 REPLY 1

bojanvelevski
Valued Contributor

‎08-23-2021 01:48 PM

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

Exercise_2021_08_23.slp
0 Kudos