Combining two table with different columns name

I'll walk your through it step-by-step to see what's happening at each step.

To demonstrate how we are preping the replacement values for use in List.ReplacementMatchingItems:

• Create a new blank query: = tblReplacement[Sipee]
  • Rename the query "Sipee"
  • Do the same for tblReplacement[Siebel]
  • What you you should have are two queries containing a list of values for each respective column in your replacement table
• Create another blank query: = List.Zip( { Sipee, Siebel} )
  • This query contains a list of lists of old/new pairs, for example {Column1_Old, Column1_New}
    • To check, click in the gray area next any "List" row (clicking of the "List word will expand that list) to see which values are in that list.
• *List.Buffer() simply puts this list of lists in memory, so that the matching step is faster
• So ultimately, we are creating a list of each row-value pair for Sipee and Siebel

Now for what List.ReplaceMatchingItems is doing:

• Table.TransformColumnNames(#"En-tetes promus", each...
  • Translation: "For each column name in the table", represented further by {_}
• List.ReplaceMatchingItems(list as list, replacements as list, optional equationCriteria as any) as list
  • Lists as list: for this parameter we use is {_}, which represents each column name
  • Replacements as list: using our replacement table, essentially what this does is if any of the column names matches any the first (old/sipee) items in the old/new pair, replace it with the second (new/siebel) item for that match
  • equationCriteria is Comparer.OrdinalIgnoreCase, which just says don't mind mismatched cases
• Finally, we wrap the list of replaced values in Text.Combine which converts each list item back to a text value.

As for why it isn't working, it's hard to say by looking at the error you received and without having your file. But try those test queries above to get a feel for it and see if it makes more sense.