How to do mapping from one column (table 1) to one other column (table 2) in Power Query

[Anonymous]

Hello,

I am trying to create a kind of conditional column from [Country] of Table 1 with [Country] of Table 2.

The goal is Country Table 1 = Country Table 2 then take Country Table 2.

But the issue is that I have different Countries that are not matching because of typology.

For exemple : The contry Congo is coming as "Congo (Republic of)" in Table 1 and Congo in Table 2. 

This need to be done in Power Query as I use this conditional column as a Key to do a merge.

Any idea of how this can be done please ? 

Thanky you for your help.

[mickey64]

For your reference.

Step 1 : I duplicate 'Country' column of Table 1.

Step 2: I  split the column by delimiter 'space'.