replacing many joins with a find and replace

[wonka1234]

Hi,

I am trying to replicate the following joins:

It needs to be replicated as the field names and the logic of how these field names are formed have changed from the right side. The left side field remains the same which is the same key for each join.

Ie Join 1 :

Join 2: 

and so on.

I was thinking do a concatenation of the new fields into one field(lets call it 'key'), and find it within the one field (n_account_id) and append all the new fields to the dataset.

Is this the best way to find the account ID in these newly created fields? Will it replicate all these joins? 

[Robin_McIntosh]

Do you have some sample data that can be dummied up?